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 / swapna

Answer Posted / swapna

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 ?

3 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are the types of containers in ssis?

1231

What are sql dirty pages?

1081

Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

935

What is a primary index?

977

What are the different editions available in sql server 2000?

1111

How can change procedure in sql server?

1126

What is the maximum size of sql server database?

1058

What is indexing a document?

1087

What are a database and a data warehouse?

1071

What command is used to create a database in the sql server and how?

1240

What do you mean by an execution plan?

1187

How to find the version of sql server? : sql server database administration

1162

Is truncate autocommit?

991

What happens if an integer is too big for int date type?

1024

Is natural join and equi join same?

1029