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 insert multiple rows with a subquery?
What are the tool windows in sql server management studio? : sql server management studio
What is transactional replication?
Why do we use trigger?
Explain having clause?
What stored by the tempdb ? : sql server database administration
Explain about merge replications?
Does a full backup include transaction log?
What is BLOCK statements in SQL?
What is difference between primary key and foreign key?
What are the different methods available under sqlcommand class to access the data?
What are horizontal and vertical scaling?
What are data files?
How to concatenate two binary strings together?
How do I start sql server agent automatically?