Indexing Strategy for Ad Hoc queries of a Data Warehouse.
Posted on 2003-03-10
I have a table of denormalized data which is approximately 150 columns wide. It will grow to approximately 150,000 rows or so.
The front end creates ad hoc queries which allow pretty much any column to potentially be part of the where clause.
Currently, I capture the queries that are being run, and their execution time so that I can create composite indexes for frequently run and or particularly slow queries.
A successful answer would ideally include a link or two to articles from respected sources as well as personal experiences.