Interested to Buy Any Domain ? << Click Here >> for more details...
What are indexes, and what are the different types?
- 3 Answers
- 1396 Views
- I also Faced
- E-Mail Answers
Answer Posted / nashiinformaticssolutions
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 difference between function and procedure in pl/sql?
If a cursor is open, how can we find in a pl/sql block?
Can a procedure in a package be overloaded?
how to drop an existing view in mysql? : Sql dba
Is nosql faster than sql?
What are the two virtual tables available at the time of database trigger execution?
Is pl sql still used?
Explian rowid, rownum? What are the psoducolumns we have?
What are the qualities of 2nf?
What is bulk collect in pl sql?
what are the join types in tsql? : Transact sql
explain the advantages and disadvantages of stored procedure? : Sql dba
What is query execution plan in sql?
What is coalesce in sql?
What is schema in sql?
