What are indexes and mention different types of indexes?
- 1 Answers
- 597 Views
- I also Faced
- E-Mail Answers
Answer / Lakki Rani
Indexes are database objects that speed up data retrieval by creating a quick-access pointer to the data. They allow for faster search, sort, and navigation operations.nnThere are various types of indexes, including:
1. Clustered Index: organizes the data in the table based on the index column.
2. Non-Clustered Index: stores a copy of the indexed columns along with a pointer to the actual data rows.
3. Unique Index: ensures that each indexed value is unique within the table.
4. Primary Key Index: serves as the primary key for the table and enforces uniqueness and integrity constraints.
5. Full-Text Index: optimizes search queries on text data, such as search engines.
| Is This Answer Correct ? | 0 Yes | 0 No |
What are the types of data-driven testing?
How to test a dts package created for data insert update and delete?
What is load testing and give some examples of it?
What is the test scenario to test a database migrated from one sql server to another?
What is performance testing and what are the bottlenecks of performance testing?
What is the database trigger?
What is the process of database testing?
How to test a dts package created for data insert update and delete? What should be considered in the above case while testing it?
What we normally check for the database testing?
In database testing, what all things are required for writing good test cases?
What do we usually check in database testing?
What is ddl and what are their commands?
Automation Testing 
