Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Exclusive OR
- Thread starter sem
- Start date
SpiritOfLennon
IS-IT--Management
select data from table where (field = value or field2 = value2) and not(field = value and field2 = value2)
should work
SOL
I'm only guessing but my guess work generally works for me.
should work
SOL
I'm only guessing but my guess work generally works for me.
Supposedly Oracle is smart enough to not execute every query twice (optimization...).
My experience is that unions and minus work generally better than or's, but you can try both approaches anyway.
And having an index over the field/s you select (at least the first one in order) should help you. Union and intersect algorithms order your data before executing.
My experience is that unions and minus work generally better than or's, but you can try both approaches anyway.
And having an index over the field/s you select (at least the first one in order) should help you. Union and intersect algorithms order your data before executing.
- Status
