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.