Steve Endow had a fantastic session on optimizing SQL queries at the GP Tech conference. This post was an outgrowth of that.
Dynamics GP Land: Adding or dropping SQL indexes temporarily on production database tables
Dynamics GP Land: Adding or dropping SQL indexes temporarily on production database tables
Archived post from 2017. Dynamics GP and the links it points to have changed since; check current documentation before relying on version-specific steps.