Effectively, this will periodically determine top index candidates for your workload. It currently runs in a recommendation mode, but you can also have it run fully automated if you uncomment a line in the file.
Tuesday, December 04, 2007
Tips, Tricks, and Advice from the SQL Server Query Optimization Team : Fun for the day - Automated Auto-Indexing!
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment