** temporary,queue table statistics

From: A Joshi <ajoshi977_at_yahoo.com>
Date: Sun, 28 Dec 2008 09:02:51 -0800 (PST)
Message-ID: <151884.50999.qm@web57503.mail.re1.yahoo.com>


   About statistics for temporary table :

Is it best to have no statistics or Are they needed? Are they OK? Is there a problem if they have statistics? Any side effects.

I mean as such they do not have any rows so one would expect no statistics. If the data contained in them is known : then is it advisable to create a session : then populate the temp table and then gather statistics on them. Any issues with that. Or is it create a regular table with same structure then populate with representative data. Just trying to get the input on this and any exceptions/issues. Thanks

On one hand oracle says statistics on temp table is not supported but it also has note like :

Metalink note 403587.1 does talk about gathering statistics.


What about queue tables. Same questions for queue tables. Thanks

Received on Sun Dec 28 2008 - 11:02:51 CST

Original text of this message