Re: Analyzing Table

From: Roel Toledo <dontsendmailstome_at_bogusmail.com>
Date: Mon, 29 Oct 2001 07:58:29 GMT
Message-ID: <F_7D7.88570$WW.4827418@bgtnsc05-news.ops.worldnet.att.net>

"Alfonso Fecál" <AlfonsoF_at_hotmail.com> wrote in message news:wrwC7.40087$%B6.16081144_at_typhoon.southeast.rr.com...
> Sorry if this question is silly to the group. If I have a table with
> zero rows, do I need to analyze it, or will the optimiser behave the
> same way whether it is analyzed or not.
>
> In other words, does it know from looking at the LAST_ANALYZED column
> whether or not the NUM_ROWS value of zero is defaulted or calculated.
>
> I am speaking of 8.1.6.x

If your table changed significantly (e.g. from 10,000 rows to zero rows) you need to analyze it again. Received on Mon Oct 29 2001 - 01:58:29 CST