Create Index myIndex On myTable(myColumn)
What type of Index will get created after executing the
above statement

Answer Posted / rams

Non-clustered index. Important thing to note: By default a
clustered index gets created on the primary key, unless
specified otherwise.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Define right outer join in sql server joins?

734


Explain the advantages of merge replication?

680


how many triggers you can have on a table? : Sql server database administration

713


What is the usage of sign function?

774


What is Extended user-defined?

712






Explain nested join?

740


Explain datetime2 data type in sal server 2008?

708


How to write a query with a full outer join in ms sql server?

729


How to loop through returning rows?

737


What are out-of-range errors with date and time literals?

726


Can truncate be rolled back?

703


What’s the distinction between dropping a info and taking a info offline?

809


Describe in brief sql server monitoring ways.

754


What is advantage data architect?

682


What is the difference between dataadapter and datareader?

729