We have table Emp declared with Non Unique Secondary index on Emploc and PI on some other column say Empid.
Now while loading the table EMp Which one of the following approach is more efficient and why ?
1. Drop the secondary index
2.Load the table
3.Recreate the secondary index.
Load the table directly without dropping the secondary index.
Please consider both the approaches for below scenarios
--When the table is large and performing large no.of inserts
--When the table is large and performing small no.of inserts
--When the table is small and performing less no.of inserts
rights to materials on this website, the rights you grant to your submissions to this website, and your responsibilities regarding your conduct on this website.