Optimizing delete SQL - Level Extreme

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

Optimizing delete SQL

Message

De

17/02/2011 17:20:35

Naomi Nosonovsky
Wisconsin, États-Unis

À

17/02/2011 17:16:25

Michel Fournier
Level Extreme Inc.
Petit-Rocher, Nouveau-Brunswick, Canada

Information générale

Forum:

Microsoft SQL Server

Catégorie:

Syntaxe SQL

Titre:

Re: Optimizing delete SQL

Versions des environnements

SQL Server:

SQL Server 2008

Application:

Web

Divers

Thread ID:

01500559

Message ID:

01500619

Vues:

38

>>Having clustered index on it will make sense, IMHO.
>
>It is the default. I didn't do anything to have it clustered.

Yes, default in SSMS table designer. It makes sense for integer identity fields.
http://blogs.lessthandot.com/index.php/DataMgmt/DBProgramming/best-practice-don-t-not-cluster-on-uniqu

If it's not broken, fix it until it is.

My Blog

Click here to load this message in the networking platform