'S36: Run query planner on barcode report, Activity Report and
Taxable Report
â— Query execution planner: Queries are utilizing the
indexes added during the earlier stage.
â— In order to prevent query from performing a full table
scan, added indexes for trakgear.trakgear_updates table
columns ( ~400k - 100k rows)
â— Applied indexing on trakgear.equipment, that brought
rows scan from ~40k to >1k'