This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
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


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
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".
 
 
subject: How to compare two queries based on efficiency
 
Similar Threads
Jasper reports Two queryString in one Jrxml
Duplicate recs in SQL
best way of querying?
how to fetch data from resultset containing result of two queries
DeadLock