Re: ** temporary,queue table statistics
Date: Sun, 28 Dec 2008 11:19:12 -0600
What Oracle version?
On Sun, Dec 28, 2008 at 11:02 AM, A Joshi <ajoshi977_at_yahoo.com> wrote:
> 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
-- Andrew W. Kerber 'If at first you dont succeed, dont take up skydiving.' -- http://www.freelists.org/webpage/oracle-lReceived on Sun Dec 28 2008 - 11:19:12 CST