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
Define right outer join in sql server joins?
Explain the advantages of merge replication?
how many triggers you can have on a table? : Sql server database administration
What is the usage of sign function?
What is Extended user-defined?
Explain nested join?
Explain datetime2 data type in sal server 2008?
How to write a query with a full outer join in ms sql server?
How to loop through returning rows?
What are out-of-range errors with date and time literals?
Can truncate be rolled back?
What’s the distinction between dropping a info and taking a info offline?
Describe in brief sql server monitoring ways.
What is advantage data architect?
What is the difference between dataadapter and datareader?