Re: tuff query, Needs to be faster.

Michael,

Have you tried using the EXPLAIN utility ? It might give you some insight on how the optimizer is interpreting your sql. Once you do that, try using some SQL "hints" to force the SQL to be executed the most efficient way. Last of all, since you tables are relatively small, the optimizer might be skipping the indexes you have on your table columns. If it IS using the indexes, make sure the data dictionary has good statistics by running the analyze command on all your tables and indexes. ( i.e. SQL> analyze index <index name> compute statistics )

Cliff Received on Wed Jun 04 1997 - 00:00:00 CDT