Re: Global Temporary Table Scalability Problem

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Tue, 10 Feb 2004 12:33:24 GMT
Message-ID: <oc4Wb.50654$Wa.47261@news-server.bigpond.net.au>

"william milbratz" <milbratz_at_hotmail.com> wrote in message news:cee3515e.0402090843.1ffda63f_at_posting.google.com...
> Hi Folks,
>
> Manually setting table statistics (dbms_stats.set_table_stats) for the
> global temporary table fixed the problem. Query times decreased
> dramatically and scaled much better (almost O(1) )
>
> Happily, recomputing the statistics for the database did not wipe out
> the manually set statistics.
>
> Thanks for the feedback everyone.
>

Hi Bill,

Be assured that things get a little easier with 9i although analyzing temp tables can have rather nasty repercussions !!

Cheers

Richard Received on Tue Feb 10 2004 - 06:33:24 CST