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 |
|
rohans
Posting Yak Master
194 Posts |
 Posted - 2004-10-07 : 15:35:32
|
| My situation is seven million records(rows) in one table and growing and with five fields to form my primary key.I often wonder how big this can grow and still be useable. i plan on spliting it but it really bigg and I am thinking it might crah the server, but that is why we have test. What I really want to know is if the five fields are indexed since they form the primary key. If not should I use regular indexes or clustered? The fields datatype are smalldate,money,nvarchar,char and int.All help appreciated. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-10-07 : 16:20:41
|
quote:
SQL Server automatically creates a unique index to enforce the uniqueness requirement of the PRIMARY KEY constraint. If a clustered index does not already exist on the table, or a nonclustered index is not explicitly specified, a unique, clustered index is created to enforce the PRIMARY KEY constraint.
Tara |
 |
|
|
|
|
|
indexing on many records