wood burning stoves 2.0*
The moose likes JDBC and the fly likes How to compare two queries based on efficiency Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "How to compare two queries based on efficiency" Watch "How to compare two queries based on efficiency" New topic
Author

How to compare two queries based on efficiency

raj malhotra
Ranch Hand

Joined: Feb 22, 2007
Posts: 285
Hi
If i have given two queries with same purpose,How can i find out which is more efficient?
Thanks
Raj
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

Databases include query analysis tools for this purpose. Which database are you using?


JavaRanch FAQ HowToAskQuestionsOnJavaRanch
raj malhotra
Ranch Hand

Joined: Feb 22, 2007
Posts: 285
Oracle 10g
quick googling result in Oracle Query Analyser 2.0.3. I hope you are talking about it.

thanks
Raj
[ December 18, 2008: Message edited by: raj malhotra ]
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

Originally posted by raj malhotra:
Oracle 10g
quick googling result in Oracle Query Analyser 2.0.3. I hope you are talking about it.

thanks
Raj

[ December 18, 2008: Message edited by: raj malhotra ]


Nope. Oracle has its own tools to do this. Have a read through your Oracle documentation for "explain plans".
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: How to compare two queries based on efficiency