WINDOW SORT [message #533472] |
Wed, 30 November 2011 03:29 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/2d72ca15c4878e08652138a08081c08e?s=64&d=mm&r=g) |
sachi09
Messages: 22 Registered: October 2011 Location: India
|
Junior Member |
|
|
In my insert query, Window sort takes longer time i.e. 93% of total execution time, How do i reduce this time? are there any tuning parameters availabe for this?
|
|
|
|
|
|
Re: WINDOW SORT [message #533489 is a reply to message #533486] |
Wed, 30 November 2011 04:11 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/2d72ca15c4878e08652138a08081c08e?s=64&d=mm&r=g) |
sachi09
Messages: 22 Registered: October 2011 Location: India
|
Junior Member |
|
|
Thanks again,
Can you give me idea how to implemet this & how does it helps in window sort? Im performing just insert operation,inserting data into table by selecting(having analystical function) from another table.
[Updated on: Wed, 30 November 2011 04:15] Report message to a moderator
|
|
|
|