easy5 pts · first answer countssqldatabase-indexing

Purpose of a database index

Your query SELECT * FROM orders WHERE customer_id = 42 is slow on a table with 10 million rows. What does adding an index on customer_id mainly do?

A.It compresses the table so it uses less disk spaceB.It makes INSERT and UPDATE statements fasterC.It lets the database find matching rows without scanning the whole tableD.It caches the full result of the query in memory forever

← How to store passwords What stateless means in REST →