Home » Other » Client Tools » Column Header
Column Header [message #512301] Sat, 18 June 2011 04:36 Go to next message
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
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.
Previous Topic: Job to be moved to another database
Next Topic: Update failed ORA-01722:invalid number
Goto Forum:

Current Time: Sat Sep 23 15:15:25 CDT 2023