Secondary index Clarification

Database
Enthusiast

Secondary index Clarification

Hi,

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 ?

Approach 1:

1. Drop the secondary index

2.Load the table

3.Recreate the secondary index.

Approach 2:

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

Tags (1)