How to Add Invisible Indexes in SQL Server Enterprise Edition
17 Comments
Every now and then, a client says, “We want to add indexes to this third party application, but if we do, we’ll lose support.” No problem – enter indexed views. Say our vendor app is the Stack Overflow database, and the app constantly queries Users by display name: USE StackOverflow; GO DropIndexes; SET STATISTICS IO…
Read More