Column Header [message #512301] |
Sat, 18 June 2011 04:36 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/7e799f633d66957ca02c2d7e9437ee9d?s=64&d=mm&r=g) |
lexotan
Messages: 1 Registered: June 2011
|
Junior Member |
|
|
Hi everyone,
When I click on a column header, e.g order by, does the query execute again with "order by" clause or use the same execution plan and give me fast result?
|
|
|
Re: Column Header [message #512302 is a reply to message #512301] |
Sat, 18 June 2011 05:25 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
John Watson
Messages: 8944 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
Hi - that will depend entirely on what tool you are using. If you say what tool, perhaps someone can answer! Perhaps the statement is run again with an ORDER BY clause, or perhaps the results are cached by the client and sorted locally?
Alternatively, you could enable SQL tracing on your client to see if the statement is sent again, or from the database side query v$session and v$sql to see what code is being executed by your session.
|
|
|