Is there a way to tell optimizer not to use index for reads?
Other than using query hints to force different indexes, or using Query Store to force plans that don't use the index, no.  There's no way to &quot;hide&quot; an enabled index from the query optimizer.