You can, if necessary, index every column in the table to dramatically improve search and sort performance.
- 1. Data Model Design
- from Effective SQL: 61 Specific Ways to Write Better SQL, First Edition
- Publisher: Addison-Wesley Professional
- Released: December 2016
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/
Share this highlighthttp://www.safaribooksonline.com/a/effective-sql-61/20902363/