SQL Query Latency Under Multi-Tenancy | Dataford Interview Questions

Explain how you would optimize an existing database query that is experiencing latency issues under heavy multi-tenant load.

Assume the query must continue returning the same business result, but it is slow at peak traffic. Describe the changes you would make to the SQL and supporting schema or indexing strategy, and how you would verify the improvement.

Output

A concise optimization plan for the query
The main SQL changes you would make
The database changes you would recommend to support the faster query

Schema

cases

Column	Type	Description
case_idPK	BIGINT	Unique case identifier
tenant_id	INT	Tenant that owns the case
status	VARCHAR(20)	Current case status
updated_at	TIMESTAMP	Timestamp of the last case update
priority	VARCHAR(20)	Optional case priority

Your question is SQL Query Latency Under Multi-Tenancy. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem

Explain how you would optimize an existing database query that is experiencing latency issues under heavy multi-tenant load.

Output

A concise optimization plan for the query
The main SQL changes you would make
The database changes you would recommend to support the faster query

Schema

cases

Column	Type	Description
case_idPK	BIGINT	Unique case identifier
tenant_id	INT	Tenant that owns the case
status	VARCHAR(20)	Current case status
updated_at	TIMESTAMP	Timestamp of the last case update
priority	VARCHAR(20)	Optional case priority

Your question is SQL Query Latency Under Multi-Tenancy. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.