Interested to Buy Any Domain ? << Click Here >> for more details...
What are indexes, and what are the different types?
- 3 Answers
- 1343 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 sql clause?
what are the properties and different types of sub-queries? : Sql dba
What is exception? What are the types of exceptions?
What is the purpose of normalization?
what are wild cards used in database for pattern matching ? : Sql dba
What is primary key in db?
Why self join is used in sql?
explain the options of myisamchk to improve the performance of a table. : Sql dba
What is range partitioning?
What is the difference between the repeatable read and serializable isolation levels? : Transact sql
Which is faster view or stored procedure?
What are the steps for performance tuning.
Which is better trigger or stored procedure?
What is the difference between inner join and left join?
Where is sql database stored?
