| Column Header [message #512301] |
Sat, 18 June 2011 04:36  |
 |
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  |
John Watson
Messages: 8869
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
