Column Order in an Index

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Sarvesh Singh » Column Order in an Index

42 posts, Page 5 of 5

«««1 2 3 4 5

Column Order in an Index

Rate Topic

Display Mode

Topic Options

Author

Message

dg1407

Posted Saturday, November 27, 2010 10:36 PM

SSC Rookie

Group: General Forum Members
Last Login: Sunday, August 05, 2012 10:02 AM
Points: 48, Visits: 61

I agree with the "spend a little more time with the article" focus.When i first read the topic, i got interested, and it was an interesting read, but i do think it also was a little bit shallow and with some lack of research, even more if you consider you're talking about, i think, one of the more complex topics on database development.

It's just constructive criticism.

Regards
DG

Post #1027018

sandippani

Posted Saturday, May 11, 2013 7:07 AM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Saturday, May 11, 2013 11:40 AM
Points: 527, Visits: 187

Nice attempt. Here in this article you should explain why SQL server does like this. I'm referring to the Index Statistitics. You can also mention in the article that if all of the columns are used as predicate, order doesn't matter more precisly it is about the leading column of the index matters not the order.

Post #1451826

« Prev Topic | Next Topic »

42 posts, Page 5 of 5

«««1 2 3 4 5

Permissions