What does an index speed up?
QuizEasy-MediumAsked in: Amazon, Coupa, TCS
You add an index on orders(customer). Pick every true statement.
- Queries such as WHERE customer = 'Acme Ltd' can find matching rows without reading the whole table
- Inserts and updates of customer get slightly slower
- The index uses extra storage
- WHERE customer LIKE '%Ltd' becomes fast too
This question is part of Pro+
Pro+ opens every question in Interview Prep and the mock interview. Every article and the first 2 questions of each topic stay free. Hands-on Selenium and API tasks follow their course lesson's own lock.