SQL · interview question

What is the healthiest performance judgment around indexes and access patterns?

Multiple choiceHardchapter-11-curatedpremiumsqlindexes-and-access-patterns

sql

CREATE INDEX idx_orders_customer_id ON orders(customer_id);

Measure before optimizing, then change the part that actually dominates cost instead of guessing from style alone.Solve the symptom with comments only and avoid changing the code shape around indexes and access patterns.Delay clarity until production traffic reveals the edge case and then patch it under pressure.Keep indexes and access patterns implicit so the script stays short and hope the next engineer infers the rule.

Answer and explanation

Correct answer

A. Measure before optimizing, then change the part that actually dominates cost instead of guessing from style alone.

Why

Premature optimization is usually weaker than targeted optimization backed by measurement.

Test yourself on SQL

A free test with instant, explained results. No account needed.

Start free test

All SQL questions →

What is the healthiest performance judgment around indexes and access patterns?

Correct answer

Why

More SQL questions