Home » SQL & PL/SQL » 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: 7212
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: Wed Jan 17 15:13:05 CST 2018

Total time taken to generate the page: 0.03802 seconds