Thanks for very clear overview of indexing considerations. A related topic that is sometimes overlook is the challenge of predicting the effects of an individual index on the workload as a whole. A recent article by Ami Levin, The Hidden Menace of CREATE INDEX, highlights this issue with some vivid examples. Worth a read.