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