Re: ** statistics for zero row table - Yes or No?

From: Riyaj Shamsudeen <riyaj.shamsudeen_at_gmail.com>
Date: Sun, 23 Aug 2009 22:30:53 -0500
Message-ID: <203315c10908232030y62b4da87pbee248bc20044d56_at_mail.gmail.com>

 >> 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.

Cheers

Riyaj Shamsudeen
Principal DBA,
Ora!nternals - http://www.orainternals.com Specialists in Performance, Recovery and EBS11i Blog: http://orainternals.wordpress.com

On Sun, Aug 23, 2009 at 4:25 PM, A Joshi <ajoshi977_at_yahoo.com> wrote:

> Hi,
> 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
> http://mail.yahoo.com
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Sun Aug 23 2009 - 22:30:53 CDT