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
Why main is user defined function?
Can another user execute your local temporary stored procedures?
What is repeatable read?
what data regions are and what are the different data regions?
Where views are stored in sql server?
Explain encryption of entire databases without the need for application changes in sql server 2008?
List down some advantages of sql stored procedure?
What are .mdf files?
What is right outer join in sql server joins?
Explain what is log shipping?
What is usually the first word in a sql query?
How to get a list of columns using the "sp_help" stored procedure in ms sql server?
What are the restrictions that views have to follow?
What is a coalesce function?
What is the difference between primary key and unique constraints?