Re: Disabling/Enabling index before bulk loading

[Ravi Krishna <srkrishna@xxxxxxxxx>]

I am very suspicious of why you need 16 indexes. Are you sure all those indexes are actually being utilized?

Try executing the attached query, You may find find some are really not needed.

This is a DATAMART application and the indexes are to satisfy a large number of queries possible from tableau. Keep in mind

this table has 200+ cols. 

That said, it is possible that a few of them may be unnecessary.  I will run your script and check that out.

thanks for the script.