Re: ** statistics for zero row table - Yes or No?
Date: Sun, 23 Aug 2009 22:30:53 -0500
>> Going further what if the table size is over 1 MB and zero rows ?
Can you elaborate this? Are you saying that rows gets added and gets deleted ? and then you collect stats while the table is empty, Like a typical interface table in EBS11i?
If this is the case, then strategy might be little bit different. But, we need little bit more information before we can proceed further.
On Sun, Aug 23, 2009 at 4:25 PM, A Joshi <ajoshi977_at_yahoo.com> wrote:
> Is it advisable to analyze (or dbms_stats) for a table that has zero rows.
> Going further what if the table size is over 1 MB and zero rows ? What are
> the pros and cons. If it is single table select then it is simpler : however
> for multi table join select : how would that be affected by zero row tables
> : with statistics and without. Thanks.
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around