Does Column Order Affect Clustered Index Performance?

In a table definition, does the physical location of the columns that make up the clustered index affect the performance of a clustered index?

Table A
Name varchar(30) Not NULL
Home_Phone char(10) NULL
Other_Phone char(10) NULL
Company_ID char(9) NOT NULL <--PRIMARY KEY
Location_# int NOT NULL <--PRIMARY KEY
Sex char(1) NOT NULL
Age int NOT NULL

Table B
Company_ID char(9) NOT NULL <--PRIMARY KEY
Location_# int NOT NULL <--PRIMARY KEY
Name varchar(30) Not NULL
Home_Phone char(10) NULL
Other_Phone char(10) NULL
Sex char(1) NOT NULL
Age int NOT NULL

I always thought it did, but I can't find any documentation to back this up. Perhaps I'm mistaken.

Thanks, DaveI don't believe the order of the columns make a difference. You just want to know that the clustered indexes is stored in sorted order at the leaf level, on inserts, updates, the clustered index is taken into consideration.

HTH

Documentation for RDL (Report Definition Language)

Hi,
I am searching for a document or the specification of RDL (Report Definition
Language). Does anyone know a good book or an online documentation dealing
with RDL?
Best regards,
ChristianReporting Services is still in beta so you aren't likely to
find any books out on the subject yet. You can sign up for
the beta to access some of the specifications in the help
file for the product:
http://www.microsoft.com/sql/reporting/default.asp
-Sue
On Mon, 10 Nov 2003 18:24:33 +0100, "Christian Nein"
<christian@.nein.de> wrote:
>Hi,
>I am searching for a document or the specification of RDL (Report Definition
>Language). Does anyone know a good book or an online documentation dealing
>with RDL?
>Best regards,
>Christian
>