Add missing indexes to codeintel tables
Created by: eseliger
There were two really slow queries I found on dotcom; as it turns out, they were missing and index on two columns that were filtered by. This brings down the HasRepository
query from 580ms to 0.082, and the IsQueued
query from ~1100ms to 0.141ms.
This also seems to propagate into other codeintel queries as the congestion on these tables is reduced. Overall, we see a 10% CPU usage reduction on dotcom.