Re: Help with suddenly long running query, 7.3.4.3/AIX

From: Christopher M. Day <christopher.day_at_rdbms.freeserve.co.uk>
Date: Fri, 05 Mar 1999 22:35:53 +0000
Message-ID: <36E05C49.22D74412@rdbms.freeserve.co.uk>

James,

For the three tables you missed out analyzing, retry with ESTIMATE rather than compute (the estimate is good).

For index statistics use ANALYZE INDEX <index_name>

Chris.

James wrote:
>
> Actually, we have computed statistics for all (except for three table due to
> size) and all of the tables involved with this are computed. I thought that
> computing table statuistics would compute the index statistics, is there a
> difference?
>
> Thanks
> James
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Fri Mar 05 1999 - 16:35:53 CST