Additional Notes
What should drive index selection on a table?
Track: Java
Topic: SQL for Java Devs
Focus: Indexes
Java: Indexes
Answer
The filters, joins, and sorts your real queries use most often.
Indexes are there to accelerate specific query patterns. Good schema design starts from how the application reads and filters data, not from a generic rule to index everything.
Indexes are there to accelerate specific query patterns. Good schema design starts from how the application reads and filters data, not from a generic rule to index everything.
Topics: Indexes Java SQL for Java Devs