|
-
Apr 14th, 2006, 08:21 AM
#1
Thread Starter
Frenzied Member
[RESOLVED] SQL Server, Clustered Index
Table, with 18M records, has a compound PK of ORDER_NUM and ORDER_LINE_NUM. (Every order can have many lines)
There are many time that I will need to query for the lines of a single order, so am considering a clustered index.
My questions is:
Do I make the index associated witht the compound PK clustered or should I have a seperate clustering index which only includes the ORDER_NUM column?
Declan
Don't forget to mark your Thread as resolved.
Take a moment to rate posts that you think are helpful 
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|