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
Explain linked server in sql?
Explain encryption of entire databases without the need for application changes in sql server 2008?
How many servers can we create in a single subscription?
What is 2nf normalization?
Can group by and orderby be used together?
How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?
Explain the difference between cross join and full outer join?
What is a ddl statement?
How to see the event list of an existing trigger using sys.trigger_events?
Which table keeps information about stored procedures?
What is the new security features added in sql server 2014? : sql server security
What are the filtered indexes?
How to recover from sql injection? : sql server security
What is mean by clustered index and non clustered index, give syntax of creation? : sql server database administration
Write an sql query for deleting duplicate rows?