What are the types of indexes available with SQL Server?
Answer Posted / nagabhushan
Indexes are of two types,Clustered Index and non Clustered
Index,when you create Clustee index on tables all the rows
in the tables are stored in the order of the clustered
Index key,So there will one cluster index in the table.Non
Clustered Index have there own storage seperate from the
table data storage.Non Clustered Index is stored in the
form of B-trees.
| Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
Explain trigger and trigger types?
What are the options which must be set to allow the usage of optimistic models?
What is a file group?
How to create user messages with print statements in ms sql server?
What command would you use to create an index?
What do you mean by an execution plan? How would you view it?
Where does the copy job runs in the log shipping primary or secondary? : sql server database administration
Tell me what do we need queues in sql service broker?
What is the default value of an integer data type in sql server 2005?
Explain transaction server auto commit?
Write a SQL queries on Self Join and Inner Join.
What is the difference between migration and upgradation in sql server?
Why use update_statistics command in sql server?
What are the acid properties?
How to change server name in sql server?