Non-clustered PK and Clustered Index vs. Clustered Compound PK

Monday, June 05, 2006

A lot has been written about the merits of multiple narrow indexes versus single larger compound indexes. This blog by Grant Fritchey yields juicy food for thought on that very topic, backed by some very thorough testing with real-world data.

MS SQL Server

posted on June 5, 2006

by Adam Anderson Comments [0] Trackback
Related posts:
T-SQL: How To Obtain SCOPE_IDENTITY() From an Object With an INSTEAD OF INSERT Trigger
T-SQL: A Simple Way to Build a String from a Column
T-SQL: How to Invert a Bit
Get More Out of Your Foreign Keys
How To Write Secure Dynamic SQL
Good article about some lesser-known differences between temp tables and table variables

Name
E-mail
Home page

	Remember Me
Comment (Some html is allowed: `a@href@title, i, strike, u`) where the @ means "attribute." For example, you can use <a href="" title=""> or <blockquote cite="Scott">.
Enter the code shown (prevents robots):
Live Comment Preview

Subscribe to Falafel Blogs

Adam Anderson	69
John Waters	60
Lino Tadros	38
Noel Rice	21
Bary Nusz	12
Mike Dugan	12
Rachel Hagerman	10
Adam Markowitz	2
Steve Trefethen	2

Total Posts	253
Comments	61