Create Index myIndex On myTable(myColumn)
What type of Index will get created after executing the
above statement
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 |
Post New Answer View All Answers
What are the types of containers in ssis?
What are sql dirty pages?
Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?
What is a primary index?
What are the different editions available in sql server 2000?
How can change procedure in sql server?
What is the maximum size of sql server database?
What is indexing a document?
What are a database and a data warehouse?
What command is used to create a database in the sql server and how?
What do you mean by an execution plan?
How to find the version of sql server? : sql server database administration
Is truncate autocommit?
What happens if an integer is too big for int date type?
Is natural join and equi join same?