Efficiency in a where clause

From: Contractor Bert Nelson <nelsonb_at_oodis01.af.mil>
Date: 4 Jun 93 22:59:10 GMT
Message-ID: <4788_at_oodis01.af.mil>

Which is more efficient in the where clause of a query

1. ...AND COND_CD IN ('A', 'B', 'C', 'D', 'E')
2. ...AND COND_CD < 'F'
3. ...AND COND_CD BETWEEN 'A' AND 'E'
4. ...AND COND_CD IN (SELECT C_EDIT_VAL FROM DOMAIN_LIST WHERE A.COND_CD = DOMAIN_LIST.EDIT_NM)

You have a condition code that can be a multitude of values, but the only ones I am interested in are A-E.

Any thoughts?

Bert Nelson
nelsonb_at_oodis01.hill.af.mil Received on Sat Jun 05 1993 - 00:59:10 CEST