Interested to Buy Any Domain ? << Click Here >> for more details...
Can we create clustered index on non primary key column
- 20 Answers
- 54925 Views
- ABC, CTS, I also Faced
- E-Mail Answers
Answer Posted / kaveri
Clustered index can be created in non primary key column
but the primary key column shoulb be created with non
clustered index. because by default primary key will have
clustered index. Each table should have only one clustered
index. So first we have to remove clustered index from
primary key column by creating it with non clustered index
and then create clustered index for non primary key column.
Note: The non primary key column should contain unique
values
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain relational data?
Can we check locks in database? If so, how can we do this lock check?
We need to perform what steps in the following order to work with a cursor?
what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?
You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?
How to restore performance issues and how to check?
How can I know what locks are running on which resource?
What are the source of constraints?
What is an execution plan? How would you view the execution plan?
Why Master database is required?
What is a transactions?
Can you explain different types of locks in sql server?
Can we insert data into view sql server?
Can we delete data from a view?
Do you know concepts and capabilities of sql server?
