Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
JavaRanch.com/granny.jsp
The moose likes JDBC and the fly likes query optimizer Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
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: 60774
    
  65

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


[Asking smart questions] [Bear's FrontMan] [About Bear] [Books by 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://aspose.com/file-tools
 
subject: query optimizer
 
Similar Threads
Performance hit using "where" clause in the query
database Issue: optimising views
Using Indexing concept for performance ?
Table Accessing through indexes
Need help - Lot of joins are slowing down my query