Interested to Buy Any Domain ? << Click Here >> for more details...
What are indexes, and what are the different types?
- 3 Answers
- 1395 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
how to convert character strings to dates? : Sql dba
how to include comments in sql statements? : Sql dba
what is 'trigger' in sql? : Sql dba
What does where 1 1 mean in sql?
What is a native sql query?
What is the difference between inner join and natural join?
How run sql*plus commands that are stored in a local file?
Can we join same table in sql?
what is a constraint? Tell me about its various levels. : Sql dba
What is multiple columns?
What is trigger in pl sql?
What is sql scripting?
State few characteristics of pl/sql?
What is the difference among union, minus and intersect?
How to run sql statements with oracle sql developer?
