Creating an index seems to be a silver bullet for optimizing a
performance of a query. If this was true, then most of performance problems would
be easy to avoid or fix, but they still exist. And there are lots of cases when
creating yet another index doesn’t help, or even make the things worst. When do
indexes help and when do you need to just take a different approach – rewriting
the query for removing a bad coding pattern. In this session I will show you
when to create an index and which query patterns don’t benefit from indexes.
You will see some reasons of the plan warnings, cardinality errors, and how to isolate
and avoid them
(no tags)
The video is not available to view online.