Understanding which missing indexes should be created

Question

Understanding which missing indexes should be created

Viewing 2 posts - 16 through 16 (of 16 total)

You must be logged in to reply to this topic. Login to reply

Paul White SSC Guru Points: 150467 More actions · Answer 1

okbangas (9/17/2011)
DTA is not very good either.

I agree with pretty much everything else you have said in this thread - but this statement is a bit harsh.

DTA does a pretty amazing job on a very hard problem - see http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.153.3796

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi

okbangas SSChampion Points: 11773 More actions · Answer 2

Ok, let's moderate my statement a bit. DTA may be an ok topplister og you Know indexing well, otherwise it is a dangerous took which can cause you trouble. The problem is really that people tend to believe that DTA solves their lack og indexing knowledge. That is not so.

Ole Kristian Velstadbråten Bangås - Virinco - Facebook - Twitter

Concatenating Row Values in Transact-SQL[/url]