December 4, 2009 at 10:03 am
In looking at some inherited applications, I see some indexes with names like:
_dta_index_MyTableName_10_1831013604__K2_K4_K8
These look like system generated names. Any idea where they come from ?
December 4, 2009 at 10:09 am
Such names are generated in Database Engine Tuning Advisor when a query workload is given to tune. The recommendations from DTA are in that fashion and some users just use that and create the Indexes and Stats.
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
December 4, 2009 at 10:24 am
homebrew01 (12/4/2009)
In looking at some inherited applications, I see some indexes with names like:_dta_index_MyTableName_10_1831013604__K2_K4_K8
These look like system generated names. Any idea where they come from ?
Bru is correct.
The _dta indicates the Database Tuning Adviser, in addition the 10 is the database_id, the 1831013604 the object_id of the table, and the K2, K4, K8 indicate that the index consists of columns 2, 4, and 8 declared in that order (iirc).
December 4, 2009 at 12:22 pm
They're from the DTA and because of that, I'd test the heck out of them to validate that they need to be there. The DTA is not to be trusted. You're better off trusting the missing index suggestions.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply