Re: tuff query, Needs to be faster.

Done, Done, and Done.

I have tried all of these things that you have mentioned, with very little improvement.
But thanks for the reply, any other suggestions.

Michael.

Noodles wrote:

> 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