Interested to Buy Any Domain ? << Click Here >> for more details...
What are indexes, and what are the different types?
- 3 Answers
- 1393 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
Which is better trigger or stored procedure?
how is myisam table stored? : Sql dba
What is your daily office routine?
Why do we go for stored procedures?
How is pl sql different from sql?
What is cursor in pl sql?
What is a pragma statement?
Does execute immediate commit?
What is prepared statement in sql?
What is minus?
What is sql and how does it work?
What is the use of function "module procedure" in pl/sql?
What is left join example?
What are the different ddl commands in sql?
What is varchar sql?
