Interested to Buy Any Domain ? << Click Here >> for more details...
What are the types of indexes available with SQL Server?
- 2 Answers
- 8140 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
List the various tools available for performance tuning?
What are blobs, tables, and Queues? Is SQL is the standard way to query blobs, tables, and queues?
What are the advantages of user defined function?
Describe in brief authentication modes in sql server.
Can we perform backup restore operation on tempdb? : sql server database administration
What is the difference between clustered and a non-clustered index?
Can the “if update (colname)” statement be used in a delete trigger?
what's the maximum size of a row? : Sql server database administration
How to test subquery results with the exists operator?
What is exclusive locks?
how you can configure a running aggregate in SSRS?
What is indexing in sql server with example?
How to change the data type of an existing column with "alter table" statements in ms sql server?
When I run the sql server 2000 setup, it just hangs. What do I do?
Explain unique key in sql server?
