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 |
|
patshaw
Posting Yak Master
177 Posts |
 Posted - 2007-07-16 : 07:19:47
|
| Can someone tell me what a Hypothetical Index is and if it is of any use. When I run sp_helpindex on some tables in one of my SQL 2005 databases, I get lots of hypothetical indexes with a description similar to this:'nonclustered, hypothetical located on PRIMARY'Where have these come from? I read a Microsoft article that said they should be dropped but also said they will be named "hind_%". Mine are not. The name always starts "_dta_%". |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-07-16 : 07:23:54
|
| open books online and type this in:hypothetical objects.these are recomendations made my database tuning advisor_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
 |
|
|
patshaw
Posting Yak Master
177 Posts |
Posted - 2007-07-16 : 08:43:58
|
| Thanks Spirit. While I can see what they do and where they are created, the information in BOL is seems a little cryptic as to whether they are needed/used or not. |
|
|
|
|
|
|
Hypothetical Index??