O'Reilly logo
  • Tom Wickerath thinks this is interesting:

You can, if necessary, index every column in the table to dramatically improve search and sort performance.


Cover of Effective SQL: 61 Specific Ways to Write Better SQL, First Edition


Not necessarily a good idea, even for a read-only data warehouse. See this posting for what can go wrong! Tales From Overindexing: Too Many One Column Indexes By Erik Darling, November 29, 2018 https://www.brentozar.com/archive/2018/11/tales-from-overindexing-too-many-one-column-indexes/