Jonathan Lewis: Indexing Strategies April 19, 2009

We all know that indexes are supposed to make things go faster - but sometimes we forget that they have maintenance costs - of two types. How do you identify the optimum set of indexes for your application? How do you identify redundant indexes? How do you check whether or not an index has become inefficient and needs to be rebuilt - and how do you rebuild it most cost-effectively? This session discusses strategies for ensuring that you don't waste effort supporting indexes that shouldn't exist, and don't waste valuable batch time rebuilding indexes that don't need it.

Official Website: http://cli.gs/SauhWy