easy5 pts · first answer countssqldatabase-performance

What an index costs

You add an index on orders.customer_id because the "My orders" page is slow. What trade-off do you accept?

A.Faster lookups by customer, but slower writes and extra disk useB.Every query on the table becomes faster, and there is no write or storage costC.Reads become slower but writes become fasterD.The table can no longer have a primary key

← URL for a user’s orders try/catch around an async call →