Interested to Buy Any Domain ? << Click Here >> for more details...
What are indexes, and what are the different types?
- 3 Answers
- 1409 Views
- I also Faced
- E-Mail Answers
Answer Posted / glibwaresoftsolutions
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
How do you explain an index?
How do you modify a trigger?
what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba
describe transaction-safe table types in mysql : sql dba
Does view store data in sql?
what are the security recommendations while using mysql? : Sql dba
What does count (*) mean?
What is not null in sql?
how to rename an existing column in a table? : Sql dba
Which sql most popular?
How can we solve sql error: ora-00904: invalid identifier?
What is forward declaration in pl sql?
What are the advantages of sql? Explain
What are sql indexes?
Is primary key clustered or nonclustered?
