Interested to Buy Any Domain ? << Click Here >> for more details...
What are indexes, and what are the different types?
- 3 Answers
- 1344 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 the usage of sql functions?
What are the various restrictions imposed on view in terms of dml?
Is coalesce faster than isnull?
Are subqueries faster than joins?
What is the use of prepared statement?
How many parts of a pl sql block are optional?
How to use boolean type in select statement?
Why use truncate instead of delete?
What is blind sql injection?
Can you rollback after commit?
what are the 'mysql' command line arguments? : Sql dba
Is sql the best database?
how to enter binary numbers in sql statements? : Sql dba
Is pl sql better than sql?
What do you mean by rowid?
