Skip to main content
System Design LabZHIMA / SYSTEMS IN MOTION

Data / 05

Find data efficiently before distributing it

Run the same resource query as a full scan and an index lookup. Change table size and match ratio to compare the paths and work.

14 MIN
SELECT title FROM resources WHERE course_id = 4250,000 result rows
WALKTHROUGH · TEACHING MODEL
Preparing the 3D walkthrough
Page checkedMatch / returnQuery path
Estimated work units
1,000,000
5%
WALKTHROUGH1 / 4

Course contents