Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Clustered PK Index and Random Inserts
Message
General information
Forum:
Microsoft SQL Server
Category:
Database design
Miscellaneous
Thread ID:
01476373
Message ID:
01476376
Views:
44
Are you using the IDs from the regular table?

>I have regular tables and archive tables in my DB.
>
>On my regular tables the integer pk index is clustered. Most inserts happen at the end of the table which is normal.
>
>In my archive table, I am moving records from the regular table to the archive table. The records that are ready to be moved from the regular table to the archive table aren't necessarily in order (by pk) and aren't necessarily inserts at the end of the archive table (though they would typically be in the last 10% or so). This happens because the ready to archive status is not determined by the pk but by other criteria.
>
>Because my insert will be occurring randomly in the last 10% of the archive table, should I still use a clustered index on the archive's pk?
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform