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

  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
Received on Sun Aug 23 2009 - 16:25:36 CDT

Original text of this message