In Ruby on Rails

Method	How it loads	Number of queries	Best for
preload	Separate queries	2 (or more if multiple associations)	Simple data access without conditions
includes	Adaptive (preload or join)	2 or 1 depending on usage	General use, auto-handling
eager_load	Always `LEFT OUTER JOIN`	1 big query	Filtering/ordering/grouping with associations