The audit tables for MSSSQL are missing indices that exist on other databases (e.g. MySQL).
These tables do have an index:
Our use of indexes on the audit tables appears to be inconsistent across all db types. Indexes should be the same across all types.