How data is organized and stored impacts application
performance.
- Ensure that the data has primary keys.
- Add indexes to the table to improve query performance. Indexes
can:
- 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
queries.
- Enforce referential integrity.