Interested to Buy Any Domain ? << Click Here >> for more details...
What are indexes, and what are the different types?
- 3 Answers
- 1234 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
What is %s in sql?
Which is faster subquery or join?
Is postgresql a nosql database?
What is a unique key and primary key and foreign key?
Which one is better subquery or joins?
what is 'mysqlcheck'? : Sql dba
What is the use of stored procedures?
What is the meaning of disabling a trigger?
What is difference between pls_integer and integer?
what are the difference between clustered and a non-clustered index? : Sql dba
How do I get sql certification?
Can you select everything, but 1 or 2 fields, without writer's cramp?
How many primary keys can a table have?
How many columns should be in an index?
Is t sql a programming language?
