>>One workaround, since you have a fairly static
>>size, is to use the dbms_stats package to create
>>stats on the GTT definition.
>
>
> On your suggestinot I tried this, but dbms_stats.gather_table_stats
> gave me an error:
> ora-20000 Gatheringing statistics for a temporary table is not
> supported.
>
True enough. you can't gather stats for GTT. however, Jonathan was
referring to setting stats manually using dbms_stats.set_table_stats
--
-Stan
To reply remove the obvious ones from my email address
Received on Sat Feb 07 2004 - 01:45:11 CST
