Optimizing delete SQL - Level Extreme

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

Optimizing delete SQL

Message

From

17/02/2011 17:20:35

Naomi Nosonovsky
Wisconsin, United States

To

17/02/2011 17:16:25

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

General information

Forum:

Microsoft SQL Server

Category:

SQL syntax

Title:

Re: Optimizing delete SQL

Environment versions

SQL Server:

SQL Server 2008

Application:

Web

Miscellaneous

Thread ID:

01500559

Message ID:

01500619

Views:

36

>>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