Common Modes of Record Processing
Single record (random)
…WHERE SSN=345667899
Multiple records (no special order)
SELECT * FROM DEPT...
Multiple records (in order)
…ORDER BY SSN
An efficient storage scheme should support all of these modes
Previous slide
Next slide
Back to first slide
View graphic version