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