Which database indexing technique helps in optimizing query performance by storing data in a sorted order?

  • Bitmap Index
  • Clustered Index
  • Non-clustered Index
  • Unique Index
A Clustered Index is a database indexing technique that helps in optimizing query performance by storing data in a sorted order based on the indexed columns. This physical ordering of data on the disk allows for faster retrieval of rows, especially when queries involve range-based searches or sorting. However, it's important to note that a table can have only one clustered index.
Add your answer
Loading...

Leave a comment

Your email address will not be published. Required fields are marked *