What do you mean by index and explain different types of indexes?
Answer Posted / Krishna Chandra Arya
In a database, an index is a data structure that improves the speed of data retrieval by allowing quicker access to specific records based on certain columns. Indexes can be categorized into two main types: Clustered Indexes (which determine the physical order of data in a table) and Non-Clustered Indexes (which store the indexed columns separately from the actual data). There are also other types like Unique Indexes, Composite Indexes, and Partial Indexes.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
No New Questions to Answer in this Category !! You can
Post New Questions
Answer Questions in Different Category