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

What is the security principal at the server level that represents your session?

553


What is the xml datatype?

619


How to create a dml trigger using create trigger statements?

552


You accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover?

543


When setting replication, is it possible to have a publisher as 64 bit sql server and distributor or subscribers as a 32 bit sql server?

493






Why olap is used?

561


Can you force a query to use a specific index?

522


Explain system rowset functions?

554


How to transfer a table from one schema to another?

558


What is xdr?

558


What is implicit cursors?

551


How do I start sql server 2017?

526


Describe and explain about SQL native client?

608


Explain the different index configurations a table can have?

500


Explain features of analysis services?

519