Home » SQL & PL/SQL » SQL & PL/SQL » Better query (Oracle 11)
Better query [message #652951] Wed, 22 June 2016 13:43 Go to next message
iliyan_84@abv.bg
Messages: 18
Registered: May 2016
Location: Bulgaria
Junior Member
Hi
If I have two queries and they give my same result. How to make decision which query is better?
Which parameters to watch on excute plan and auto trace

Report message to a moderator

Re: Better query [message #652952 is a reply to message #652951] Wed, 22 June 2016 13:53 Go to previous messageGo to next message
John Watson
Messages: 8931
Registered: January 2010
Location: Global Village
Senior Member
Which query is faster? For your users, there is no other criterion.

Report message to a moderator

Re: Better query [message #652961 is a reply to message #652952] Thu, 23 June 2016 02:56 Go to previous message
Roachcoach
Messages: 1576
Registered: May 2010
Location: UK
Senior Member
John Watson wrote on Wed, 22 June 2016 19:53
Which query is faster? For your users, there is no other criterion.



Depends how often it is being called Wink You might upset the server.

@OP: Assuming runtime on both is similar enough to not matter, run them both in a test environment at expected production loads and see which one creates the least "noise" on the server.

Report message to a moderator

Previous Topic: how to get one week historical query for v$SQL
Next Topic: Need Help to convert rows into column
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu May 09 02:41:23 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.