Interested to Buy Any Domain ? << Click Here >> for more details...
What are the types of indexes available with SQL Server?
- 2 Answers
- 8022 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 the purpose of floor function?
What program is used to store the data source file?
Can we add our custom code in ssis?
what is the sql equivaent of the dataset relation object ?
How to receive returning result from a query?
how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A
What is normalization according to you and explain its different levels?
Equi join and non equi join is possible with sql server?
What is transaction server explicit transaction?
Explain the relational database management system (rdbms)?
How connect excel to sql server?
Tell me something about security and sql azure?
What is the difference between clustered and non-clustered indexes in ms sql server?
Describe the left outer join & right outer join. : sql server database administration
How to stop a loop early with break statements in ms sql server?
