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
How to select some specific columns from a table in a query in ms sql server?
What stored by the master?
What is the query and subquery?
What is the difference between insensitive and scroll cursor?
Can You Use A Stored Procedure To Provide Data To An Ssrs Report?
Can we call future method from trigger?
How to assign null values to variables or columns?
Do you know what are various aggregate functions that are available?
How does using a separate hard drive for several database objects improves performance right away?
Tell me about builtinadministrator?
What are commonly used mssql functions in php?
How to connect ms access to sql servers through odbc?
Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you
What is difference between delete & truncate commands?
Write the syntax for stuff function in an sql server?