Perform an insert /*+ append */ and see if the indexes are rendered unusable according to the user_indexes table.
David Aldridge, "The Oracle Sponge" Senior Manager, Business Intelligence Development XM Satellite Radio Washington, DC Oracle ACE
Forum Rules
Reply With Quote