Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Clustered PK Index and Random Inserts
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Conception bases de données
Divers
Thread ID:
01476373
Message ID:
01476376
Vues:
45
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--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform