|www.sum-it.nl > Courses|
> DB Design course > Method > 3. Technical optimisation > Steps > Sort
Nederlands · Search...
SortSome 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 Goal Optimisation steps Use ranges Denormalise Combine tables Store derived data Add indexes 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.|