Hi,
I have a doubt regarding making the Index Visible and Invisible.
Oracle Version used is 11.2.0.4
Scenario is:
I have DML load into a table which does truncate and load. This table have an index and since Index is used during the INSERT operation the DML takes around 50 minutes.
Since my version in > 10g, I went up with the below steps
1. Before Load, Make the Index INVISIBLE
2. Truncate the Table and Load the data.
3. Make the Index VISIBLE
In this process, I would like to know, Do I need to run the Gather Stats for the Index/Table to make sure the new set of records are indexed/gathered.
Or will Oracle itself will make sure that Index is applied on all the new records,.
Please clarfiy