Interested to Buy Any Domain ? << Click Here >> for more details...
Can we create clustered index on non primary key column
- 20 Answers
- 54791 Views
- ABC, CTS, I also Faced
- E-Mail Answers
Answer Posted / gunjan sapra
no,we can't create clustered index on non primary key just
because of the simple reason that in clstered
index,physical sorting is done while in non primary key
there might be hundreds of duplicate entries. so, if we
create clusterd index on non primary key it will get
confused and then error.
| Is This Answer Correct ? | 34 Yes | 49 No |
Post New Answer View All Answers
How should i optimize the time for execution of stored procedure having single input and many output from the different tables?
Why should we go for stored procedures? Why not direct queries?
What is data file in computer?
What are audit control procedures?
How to use old values to define new values in update statements in ms sql server?
How to create a stored procedure with a statement block in ms sql server?
What are the different types of data sources in ssrs?
What is table level trigger?
What is the function of sql server agent windows service?
How can windows applications connect to sql servers via odbc?
How to assign null values to variables or columns?
Can we write a distributed query and get some data which is located on other server and oracle database?
How to stop log file growing too big?
Explain the phases a transaction has to undergo?
What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?
