Dear all,
What is the best way to deal with Hypothetical Indexes?
Do we have to delete them after sometime or create the actual indexes to
gain performance?
Regards
KhurramHypothetical indexes should be removed. They are only supposed to exist
temporarily when running ITW. MS has published a script to remove them
(not tested by me):
http://support.microsoft.com/kb/q293177
If in doubt about what indexes to create then you can try running the
Tuning Wizard again. ITW is only as good as the data you feed it and it
won't always be right. Use it as a guide only.
--
David Portas
SQL Server MVP
--
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment