Re: How to give hints about indizes ??

Mark Prebilic <prebson_at_yahoo.com> writes:

> > And is there a possibility to automatically test some variations of
> > different optimizations so I can see which is the fastest ?
> > And where can I find out more about hints for the optimizer in general ?
> > Are there some good web pages ?

The hints are not well documented, but there is at least a list of them in the SQL reference on page 2-40. It's downloadable from technet.oracle.com, free registration. There's also a whole tuning book, but it's mostly about system administration, very little about query tuning.

In this case you may be better off doing  analyze table <foo> compute statistics for columns <bar>

Which will generate a histogram for that column so the optimizer would realize it's not very selective.

--
greg Received on Fri Nov 05 1999 - 17:37:01 CST