Interested to Buy Any Domain ? << Click Here >> for more details...
What are indexes, and what are the different types?
- 3 Answers
- 1228 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
Explain unique key in sql.
Which is faster view or stored procedure?
Why do we use joins?
How to return an array from java to pl/sql?
what are the different index configurations a table can have? : Sql dba
What is synchronized subquery?
Enlist the characteristics of pl/sql?
What are properties of the transaction?
Why do we use sql constraints? Which constraints we can use while creating database in sql?
What is int identity in sql?
How do I count duplicates in sql?
What is a data manipulation language?
Explain the purpose of %type and %rowtype data types?
Does mysql support pl sql?
What are primary key and foreign key and how they work?
