Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
aiken
Aged Yak Warrior
525 Posts |
 Posted - 2004-12-15 : 16:21:57
|
| A couple of my tables have a bunch of "hind" indexes (for example, hind_55035876_1A_2A_3A_4A). Am I correct in thinking that these are strays left over from some old index tuning wizard run, and that they are either doing no good or some harm?Can I kill 'em?Thanks-b |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2004-12-15 : 16:51:35
|
| You can kill them. |
 |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2004-12-15 : 16:53:00
|
| OK, what is this stuff?Brett8-) |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2004-12-15 : 16:54:21
|
| Tuning wizard crap. If you look in BOL under "INDEXPROPERTY" you'll find some settings that let you identify this stuff (IsHypothetical and some others) |
|
|
|
geossl
Yak Posting Veteran
85 Posts |
Posted - 2004-12-15 : 20:41:20
|
"How to Identify Real Versus Automatically-Created Indexes"[url]http://www.microsoft.com/sql/techinfo/tips/administration/autoindexes.asp[/url]quote:
Originally posted by aiken
A couple of my tables have a bunch of "hind" indexes (for example, hind_55035876_1A_2A_3A_4A). Am I correct in thinking that these are strays left over from some old index tuning wizard run, and that they are either doing no good or some harm?Can I kill 'em?Thanks-b
|
|
|
|
clarkbaker1964
Constraint Violating Yak Guru
428 Posts |
Posted - 2004-12-15 : 22:46:22
|
Good post geossl |
|
|
|
|
|
|
"hind" indexes? Can I kill them?