Interested to Buy Any Domain ? << Click Here >> for more details...
What are indexes, and what are the different types?
- 3 Answers
- 1342 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
How many types of privileges are available in sql?
What is varchar example?
What are sql constraints?
What is a table partition?
Is sql microsoft?
Does truncate require commit?
What is a string data type in sql?
What is difference between hql and native sql?
Why do we use sql constraints? Which constraints we can use while creating database in sql?
What plvcmt and plvrb does in pl/sql?
What are the parts of a basic sql query?
Can a composite key be null?
Which sql statement is used to return only different values?
What is difference between pl and sql?
Why are indexes and views important to an organization?
