Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
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

query optimizer

Ray Tsia

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

Joined: Jan 10, 2002
Posts: 60782

"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?
It is sorta covered in the JavaRanch Style Guide.
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