Non-clustered index. Important thing to note: By default a clustered inde

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

Question Posted / rams

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

Please Help Members By Posting Answers For Below Questions

How to select an exiting database using mssql_select_db()?

1048

What do you mean by normalisation?

1102

Explain sub-query?

1009

What is a View ? Can we insert, Update and delete a view?

1059

Tell me can we use custom code in ssrs?

1050

What are the different authentication modes in sql server? How can it be changed?

1138

What stored by the msdb? : sql server database administration

1051

What is use of except clause? How does it differ from not in clause?

1064

Explain about service Broker functions?

1086

How you trouble shoot when any job fails

1981

How to drop an existing stored procedure in ms sql server?

1086

How to declare and use cursor variables?

1250

Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.

1097

What will happen if a column containing char type data is changed to the nchar data type?

1149

How to defragment table indexes?

1036