or turning on monitoring for the table, then adjusting the table stats according to the monitoring stats
David Aldridge, "The Oracle Sponge" Senior Manager, Business Intelligence Development XM Satellite Radio Washington, DC Oracle ACE
Fingers and toes?
I remember when this place was cool.
select count(rowid) from... cant remember the table name thread's too long with so many INTELLIGENT answers !!
Forum Rules