Indexes typically only speed up reads while also slowing down writes (sometimes massively). SARGability of the queries is also needed to effectively use the in

Indexes typically only speed up reads while also slowing down writes (sometimes massively). SARGability of the queries is also needed to effectively use the indexes.