July 9, 2010 at 2:59 am
which one is the best performence "index or cluster index"
July 9, 2010 at 3:45 am
This was removed by the editor as SPAM
July 9, 2010 at 7:08 am
mupparaju78 (7/9/2010)
which one is the best performence "index or cluster index"
Yes!
More detailed, it depends.
Even more detailed, assuming a covering index, meaning an index that can satisfy all the requirements of the query, a nonclustered index is faster for an individual seek.
That said, It's not a good question at all. Each type of index has a different purpose and you will want to use both types of indexes. In fact, despite what I said above, you're going to use clustered indexes more than nonclustered indexes in a well designed system. This is because clustered indexes store the data at the leaf level.
Keep an eye on my blog (scarydba.wordpress.com). I'm posting three articles in two weeks as part of SQL Server University[/url]. They're all introductory articles on indexes.
"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
July 9, 2010 at 9:08 am
Grant Fritchey (7/9/2010)
Keep an eye on my blog (scarydba.wordpress.com). I'm posting three articles in two weeks as part of SQL Server University[/url]. They're all introductory articles on indexes.
Wow, thats excellent news Grant.. hmmm... will surely be in my "watch this" favs folder 🙂
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply