Answer Posted / guest
Indexes improve database performance by allowing faster retrieval of records.
Types of indexes:
• Clustered Index – Reorders table records for faster access.
• Non-Clustered Index – Stores index separately for faster lookups.
• Unique Index – Ensures all values in a column are unique.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to get the definition of a view out of the sql server?
What is 2nf example?
What is the difference between for auto and for nested?
Is it possible to create trigger on views?
What is perspective, have you ever created perspective? : sql server analysis services, ssas
List out the different types of locks available in sql server?
What is the most common type of join?
Why can there be only one clustered index and not more than one?
tell me the disaster recovery plan
What is @@error in sql?
What is 1nf normalization form?
Explain about system database?
can you implement data mining in SSRS?
What is the difference between having clause and where clause in sql server?
How do you troubleshoot errors in a SQL Server Agent Job?
