** temporary,queue table statistics
- From: A Joshi <ajoshi977@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Sun, 28 Dec 2008 09:02:51 -0800 (PST)
Hi,
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
Other related posts:
