Interested to Buy Any Domain ? << Click Here >> for more details...
What are indexes, and what are the different types?
- 3 Answers
- 1408 Views
- I also Faced
- E-Mail Answers
Answer Posted / hr@tgksolutions.com
Indexes improve query performance by speeding up data retrieval.
Types of Indexes:
1. Clustered Index: Sorts and stores data physically in the table.
2. Non-clustered Index: Creates a separate structure to store pointers to the actual data.
3. Unique Index: Ensures all values in a column are unique.
4. Composite Index: Includes multiple columns in the index.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is a mutating table and a constraining table?
list out some tools through which we can draw e-r diagrams for mysql. : Sql dba
Why is a trigger used?
How do you optimize a stored procedure in sql?
what is a constraint? : Sql dba
How can we implement rollback or commit statement in a trigger?
Can we use pl sql in sql server?
What is input buffer in sql*plus?
what is the command used to fetch first 5 characters of the string? : Sql dba
What is a unique key and primary key and foreign key?
What does truncate mean in sql?
What are conditional predicates?
What is nosql db?
how many values can the set function of mysql take? : Sql dba
Enlist the advantages of sql.
