Hello Friends I have a problem so please help me.
My problem is that we all know that is a table contain a primary key then a clustered index in generate. A Clustered Index is a special type of index that reorders the way records in the table are physically stored. Therefore the table can have only one Clustered Index.
If a have a table

and i create a primary key on Emp_Id cloumn then a B-Tree will generate(in Clustered Index)
that store the data in such a way

We know that in clustered index data always store in sorted form. Sorting always performed on the base of primary key.
My Confusion that how data will be sort if we create a primary key on more than one column
like:
Alter Table Employee
Add constraint Constraint_Name Primary Key(Emp_IId,Emp_Age)
Please anyone can explain me how data will be store in sorted form........
Thanks@@

Pankaj Kumar ChoudharyPosted May 22, 2015, 1:08 AM
Munesh SharmaPosted May 22, 2015, 12:50 AM
Nanhe SiddiquePosted May 22, 2015, 12:11 AM