Interested to Buy Any Domain ? << Click Here >> for more details...
What are the types of indexes available with SQL Server?
- 2 Answers
- 8052 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
How can sql server instances be hidden? : sql server security
you have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem? : Sql server administration
How to install sql server 2005 express edition?
what are the different stages of Report Processing?
What are the pre-defined functions in the sql server?
What specific conditions database should meet, before you can bulk copy data into it using bcp?
What is relationship? What number of sorts of relationship are there?
what is create database syntax? : Sql server database administration
How to find the version of sql server? : sql server database administration
What is the largest component inside a field?
Explain table valued parameters in sql server? Why tvp used?
How to run sql server 2005 books online on your local system?
how many clustered indexes can be created on a table? : Sql server database administration
What is sql azure database?
What is transaction server auto commit?
