Tools › Index advisor

CREATE INDEX blueprint from WHERE and JOIN

This is a starting point, not a DBA. Equality columns first, then the range, then includes for the SELECT list.

Table WHERE / JOIN columns (equality first) Range / ORDER BY columns SELECT columns to INCLUDE

Too many indexes slow writes. Look at the actual plan before you sprinkle these on production.

Learn it on a real ticket

Monday is free on WorkSQL. Write the T-SQL yourself. We mark it like a colleague would.