Sorteer table, related rows in one block

Sort Some RDBMSses have the possibility to sort tables (next to indexes of course). For list functions this can be beneficial. For example by sorting readers on postcode so the readers of one area are grouped together in one block.		Introduction 1. Scope 2. Logical Design 3. Technical Optimisation Goal Optimisation steps Use ranges Denormalise Combine tables Store derived data Add indexes Sort 4. Implementation End

Unsorted, the system must hip hop through the whole table to find the related rows.	Sorted. The system just needs to fetch one block. The rows are grouped together.
Search the documentation of your RDBMS for clustered index.
Next: Implementation