Can we create clustered index on non primary key column
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
what is a transaction and what are acid properties? : Sql server database administration
What is user-defined function?
What is the fastest way to permanently delete a 1 million row table named customers?
What is a result set object returned by odbc_exec()?
hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.
Explain indexed views and partitioned view with their syntax.
how to take backup bcp out for a column in table in sql server?
What is failover clustering overview?
How do I create an extended event in sql server?
Is it possible to update the views? If yes, how, if not, why?
In what three ways is the return statement used in a stored procedure?
How to view existing indexes on an given table using sp_help?
What is query optimization process?
What is the maximum row of a size?
Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?