Interested to Buy Any Domain ? << Click Here >> for more details...
What are the types of indexes available with SQL Server?
- 2 Answers
- 7898 Views
- Standard Bank, I also Faced
- E-Mail Answers
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
What is auditing in sql server?
What are binary string data types in ms sql server?
What is a print index?
Explain a differential backup?
What is the use of sql profiler in sql server 2012?
Ms sql server index?
How to use group functions in the select clause in ms sql server?
What is user-defined function?
What is Extended user-defined?
Where do we use trace frag?
What are the commands used in DCL?
What is inline table-value user-defined function?
Explain acid?
What function does a database engine serve in the sql server?
What is query cost in sql server?
