When do you create cluster and noncluster index?

Answer Posted / naren

If there is primary key in table clustered index created by
default ,other wise non cluster index created .

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why main is user defined function?

564


Can another user execute your local temporary stored procedures?

539


What is repeatable read?

540


what data regions are and what are the different data regions?

101


Where views are stored in sql server?

557






Explain encryption of entire databases without the need for application changes in sql server 2008?

564


List down some advantages of sql stored procedure?

557


What are .mdf files?

520


What is right outer join in sql server joins?

688


Explain what is log shipping?

578


What is usually the first word in a sql query?

594


How to get a list of columns using the "sp_help" stored procedure in ms sql server?

584


What are the restrictions that views have to follow?

557


What is a coalesce function?

661


What is the difference between primary key and unique constraints?

512