Can we create nonclustered index in a table without
creating a clustered index

Answer Posted / neelesh kumar

Yes, we can. for example we can use unique constraint
without any clustered index.

Is This Answer Correct ?    16 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is resultset concur_updatable?

660


A user is a member of the public role and the sales role. The public role has select permission on all the tables. The sales role does not have select permission on some of the tables will the user be able to select from all tables?

611


How to enter unicode character string literals in ms sql server?

654


What is index in an assignment?

616


What to perform pattern match with the like operator?

564






Can I save my report as html, excel or word? : sql server management studio

622


What is primary key, unique key, and foreign key?

643


Explain in brief about Microsoft SQL server?

636


What is order of B+tree?

761


According to you what goes into making the best database administrator? : sql server database administration

627


What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?

650


How to delete duplicate rows in sql server?

662


What is PROJECTION Operation?

683


What is collation sensitivity? Explain different types.

641


What is table valued function and scalar valued functions?

574