Experts correct me if iam wromg

when OR is used sql server finds it difficult to use the right index , mostly it does a table scan. This can bring down the performance .