The process of determining which indexes are useful and which are not. This may include removing indexes, adding indexes, re-arranging the column order of index, and changing which columns are referenced.
Stats
created |
1 year ago |
viewed |
2 times |
active |
1 year ago |
editors |
1 |
Recent Hot Answers
Should I use many single field indexes, instead of specific multi column indexes?How to know when/if I have too many indexes?
Adding a Clustered index to a HEAP table on someone else's app
How to optimize this query?
How do I know what indexes to create for a table
more »
Related Tags
index × 31sql-server × 26
mysql × 20
query-performance × 13
performance × 10
sql-server-2008 × 8
postgresql × 8
database-design × 7
sql-server-2008-r2 × 6
oracle × 5
sql × 5
primary-key × 5
optimization × 4
index-statistics × 4
clustered-index × 3
partitioning × 3
sql-server-2012 × 3
database-administration × 2
myisam × 2
oracle-11g-r2 × 2
unique-key × 2
sql-server-2005 × 2
oracle-10g × 2
db2 × 2
indexed-view × 2