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 delete database objects with "drop" statements in ms sql server?
Explain trigger and trigger types?
What is the difference between the export /import functions in sql studio and standalone sql manager? : sql server management studio
what are constraints? : Sql server database administration
what is the information that can be stored inside a bit column? : Sql server database administration
How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.
What are the types of subquery?
How to concatenate two binary strings together?
Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you
What is the command dbcc checkdb used for?
How to round a numeric value to a specific precision?
How to provide default values to function parameters?
What does the on delete cascade option do?
What do you understand by hotfixes and patches in sql server?
How to use subqueries in the from clause in ms sql server?