It's not a secret anymore!*
The moose likes JDBC and the fly likes Head First SQL query optimizer Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Head First SQL query optimizer" Watch "Head First SQL query optimizer" New topic

Head First SQL query optimizer

Yogesh Baraskar
Ranch Hand

Joined: Oct 07, 2007
Posts: 33
Hi Lynn Beighley,

Does this book covers topics related to
writing efficient sql query to reduce the execution time
and improve perfomance.
Please suggest other books also.

Thuwaragan Sundaramoorthy

Joined: Jan 11, 2007
Posts: 26
I think these are under Advanced stuff. You need to refer some advanced books on SQL tuning and performance optimization for the moment.

------------------------------<br />SCJP 1.5
Muhammad Saifuddin
Ranch Hand

Joined: Dec 06, 2005
Posts: 1321

better to have a look inside the TOC (Table of Content) of this book.

[Blog][Linkedin] How To Ask Questions On JavaRanch My OpenSource
I agree. Here's the link:
subject: Head First SQL query optimizer
Similar Threads
How to Find Out There Are Identical Records Without Using the Select?
JDBC doesn't retrieve all the results available in the MSSQL database
Hibernate 3 not able to recognize the "ON" word in sql
Please help me to convert this SQL to hibernate query
Sub query(oracle) conversion to HQL/criteria