Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-01-21 : 12:00:28
|
samo writes "I have to design a new table that will store order history information. My question is - what is the most effecient way to configure primary keys and indexes?
The history table has
OrderID
OrderLineNumber
OrderAttachment
User Name
DateModified
Each order can have multiple line numbers and each line number can have multiple attachments.
I'm wondering if it's best to have a sequence as the primary key and put indexes on orderid and line number. The select against this table will only be by OrderID and OrderLineNumber. Or if some other configuration is optimal." |
|
|
|
|
|
Table Design - Primary Keys