For a database containing millions of records, which strategy would you employ to speed up query response times?

  • Data Partitioning
  • Denormalization
  • Full Table Scan
  • Indexing
Indexing is a strategy to speed up query response times in a large database. By creating indexes on columns frequently used in queries, the database engine can quickly locate the required data without performing full table scans, leading to improved performance.
Add your answer
Loading...

Leave a comment

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