Re: ** statistics for zero row table - Yes or No?
- From: Riyaj Shamsudeen <riyaj.shamsudeen@xxxxxxxxx>
- To: ajoshi977@xxxxxxxxx
- 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.
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@xxxxxxxxx> 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
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
Other related posts:
