Interested to Buy Any Domain ? << Click Here >> for more details...
What are indexes, and what are the different types?
- 3 Answers
- 1233 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
Is primary key always clustered index?
How do we use distinct statement? What is its use?
Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?
What is before trigger?
what are the advantages of sql ? : Sql dba
What is the most restrictive isolation level? : Transact sql
How to call a javascript function from pl sql?
What is oracle and pl sql?
Explain the order of sql statement execution?
What is write ahead logging in sql server?
Is sql a case sensitive language?
What is structural independence and why is it important?
How do you use a while loop in pl sql?
Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?
What is pl sql in oracle?
