Let's say I have a table of 4 columns: A, B, C, D. A primary key is on A, B, C.
Index1: is A, D, B, C in that order Index2: A, B, C, D in that order and the primary key index: A, B, C
There are queries selecting different columns in different numbers and order. I don't all the queries that hit the table.
Are some indexes here redundant?
I collected some scripts from the web for finding redundant indexes and they don't return the same results for the database. I guess every author has their own interpretation of what constitutes a duplicate or redundant index.
Aucun commentaire:
Enregistrer un commentaire