'S36: Run query planner on Rosters(athlete information, athlete history tabs) fig. 2.11
Query execution planner: Applied indexing on trakgear.size_type_sport, that brought rows scan from ~1k to >149
In order to prevent query from performing a full table scan, added indexes for  trakgear.history_athlete table columns ( 1264794 - 1 rows)
Modified query to take advantage of date field index'