jQuery in Action, 2nd edition
The moose likes JDBC and the fly likes query optimizer Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Reply Bookmark "query optimizer" Watch "query optimizer" New topic
Author

query optimizer

Ray Tsia
Greenhorn

Joined: Jul 25, 2007
Posts: 8
I am looking for a query optimizer book.

I knew the basic knowledge about sql but I would like to see some real world practice example w/ optimizer sample.

Could someone suggest something good?
Bear Bibeault
Author and ninkuma
Marshal

Joined: Jan 10, 2002
Posts: 56150
    
  13

"Ray T", please check your private messages for an important message from me.


[Smart Questions] [JSP FAQ] [Books by Bear] [Bear's FrontMan] [About Bear]
Paul Campbell
Ranch Hand

Joined: Oct 06, 2007
Posts: 338
do you mean the optimizer as in a rules-based or cost-based optimizers? or do you mean optimizer hints?
 
I agree. Here's the link: http://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to run our stuff on 16 servers instead of 3.
 
subject: query optimizer
 
Similar Threads
Using Indexing concept for performance ?
Performance hit using "where" clause in the query
Need help - Lot of joins are slowing down my query
database Issue: optimising views
Table Accessing through indexes