Interested to Buy Any Domain ? << Click Here >> for more details...
Can we create clustered index on non primary key column
- 20 Answers
- 54241 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
Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.
Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?
What is an inner join?
How to count groups returned with the group by clause in ms sql server?
How to get a list of columns in a view using the "sp_columns" stored procedure?
How to change the data type of an existing column with "alter table" statements in ms sql server?
Tell me can we use custom code in ssrs?
How many columns can we include on clustered index ?
What are constraints in microsoft sql server?
What is a db view?
What is transact-sql language?
Explain what are magic tables in sql server?
What factors you will consider calculating the storage requirement for that view?
What is a partitioned view?
what is a deadlock? : Sql server database administration
