How data is organized and stored impacts application
- Ensure that the data has primary keys.
- Add indexes to the table to improve query performance. Indexes
- Reduce the amount of data retrieved.
- Consume less bandwidth and require less processing.
- Presort data.
- Help eliminate post-retrieval work for GROUP BY and ORDER BY
- Enforce referential integrity.