So, can indexes on really small tables (< 1000 rows) actually make a difference? (Conventional SQL Server wisdom says that they typically won't be used.)
Check out my recent post on RepeatableRead where I provide an example of where 'micro-indexes' can make a significant improvement to overall performance - at an obscenely minimal cost.
Comments