** statistics for zero row table - Yes or No?
From: A Joshi <ajoshi977_at_yahoo.com>
Date: Sun, 23 Aug 2009 14:25:36 -0700 (PDT)
Message-ID: <33197.9024.qm_at_web57509.mail.re1.yahoo.com>
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
Date: Sun, 23 Aug 2009 14:25:36 -0700 (PDT)
Message-ID: <33197.9024.qm_at_web57509.mail.re1.yahoo.com>
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-lReceived on Sun Aug 23 2009 - 16:25:36 CDT