File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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: 63532

"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!