Choice of Indexes
One approach: consider the most important queries in turn. Consider the best plan using the current indexes, and see if a better plan is possible with an additional index. If so, create it.
Before creating an index, must also consider the impact on updates in the workload!
- Trade-off: indexes can make queries go faster, updates slower. Require disk space, too.