I want some Moore

Blog about stuff and things and stuff. Mostly about SQL server and .Net
posts - 226, comments - 2295, trackbacks - 33

My Links



Hi! My name is 
Mladen Prajdić  I'm from Slovenia and I'm currently working as a .Net (C#) and SQL Server developer.

I also speak at local user group meetings and conferences like SQLBits and NT Conference
Welcome to my blog.
SQL Server MVP

My Books

SQL Server MVP Deep Dives 2
The Red Gate Guide to SQL Server Team based Development Free e-book

My Blog Feed via Email
Follow MladenPrajdic on Twitter

Users Online: who's online

Article Categories


Post Categories

Cool software

Other Blogs

Other stuff

SQL stuff

SQL Server 2005: Hypothetical index - a what?!?!

No it's not some ultra misterious indexing feature that will make your database fly like it's on steroids.

Hypothetical indexes and database objects in general are simply objects created by DTA (Database Tuning Advisor) 

Their names look like this:

Indexes _dta_index_*
Statistics _dta_stat_*
Views _dta_mv_*
Partition functions _dta_pf_*
Partition schemes _dta_ps_*

          * = some autogenerated name


If you're going to implement the recommendations given by the DTA then do rename the objects to avoid confusion.


Checking if an index is hypothetical is simple. Just run this query:

FROM    sys.indexes
WHERE   is_hypothetical = 1


kick it on DotNetKicks.com

Print | posted on Monday, July 16, 2007 1:46 PM | Filed Under [ SQL Server ]

Comments have been closed on this topic.

Powered by:
Powered By Subtext Powered By ASP.NET