How to rewrite a query using an or condition?
my query has a condition in the where caluse which has a OR part. because of the OR part the query cost increases.
is ther any way to rewrite the OR part apart from using an UNION operator.
select * from table1 a,table2 b where
a.field1 = 'CONSTANT'
and
a.field2= b.field2
and (a.field3 = 'input value' or a.field4 = 'input value')