my dog learned polymorphism
The moose likes JDBC and Relational Databases 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 and Relational Databases
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: 63857

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

[Asking smart questions] [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:
subject: query optimizer
It's not a secret anymore!