Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Analyzing Table
"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
![]() |
![]() |