Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Strange Indexes in Interprise Manager
Message
From
26/03/2003 10:23:45
 
 
General information
Forum:
Microsoft SQL Server
Category:
Other
Miscellaneous
Thread ID:
00770207
Message ID:
00770222
Views:
14
Those are index statistics, not indexes. They are created by SQL Server to help the Query Optimizer come up with a better execution plan for queries. I wouldn't worry about them since they are basically system objects maintained by SQL Server. When you right-click on a table in EM and select "Manage Indexes", notice that they don't even show up.

Roman
Roman Rehak, MCSD, MCDBA, MCSA
Competitive Computing
354 Mountain View Drive
Colchester, VT 05446-5824
802-764-1729
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform