Reply to All
Show messages
Messages
Inbox
Search
Login
1–2
Auto-indexing databases
From: Kenny J (WINGNUTKJ)
2 Sep 2009 14:40
To: Peter (BOUGHTONP)
2 of 2
36515.2
In reply to
36515.1
Dunno about others, but Microsoft SQL Server has the Database Engine Tuning Advisor which does exactly what you describe. You set it running for a while, or give it a sample workload, and it suggests indexes and statistics to create.