Interested to Buy Any Domain ? << Click Here >> for more details...
Can we create clustered index on non primary key column
- 20 Answers
- 54896 Views
- ABC, CTS, I also Faced
- E-Mail Answers
Answer Posted / pavan kumar
YES, We can create a clustered index on a non-primary
column. Check the folowing queries...
CREATE TABLE EMPLOYEES
(
empid int NOT NULL CONSTRAINT ix_pkEMPLOYEES PRIMARY KEY
NONCLUSTERED
, name varchar(25) NOT NULL
, age tinyint NOT NULL
)
CREATE CLUSTERED INDEX ixcEMPLOYEES ON EMPLOYEES (name)
| Is This Answer Correct ? | 57 Yes | 6 No |
Post New Answer View All Answers
Do you know what is difference between index seek vs. Index scan?
what is unique and xaml nonclustered index
Explain the different types of joins?
Introduction of rollup clause using sum and group by clause?
What is a trigger and its types?
What is the function of inner join?
Is INSTEAD OF trigger directly applicable to Table ?
What is query parameter in ssrs?
What is self contained scalar sub query?
How to start sql server browser service?
What is data source in connection string?
Tell me what do you mean by an execution plan? Why is it used? How would you view it?
What is the library index called?
List the data types available in mssql?
How self join is different from outer join?
