Query optimization

I have query in the form:

SELECT 'blah'

FROM table

WHERE
(conditions)

AND  
(CAT.NAME = 'eg1'

    OR
CAT.NAME = 'eg2'

    OR
CAT.NAME = 'eg3'

    OR
CAT.NAME = 'eg4'

    OR

etc
)

Any ideas on how I can make it faster?
When I query 1 cat.name it is fast, but adding more slows it down.

Any ideas?

Spike Received on Fri Nov 02 2001 - 04:49:53 CST