>
> 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.