>How long it will it take if you leave only one condition?
Where Upper( Ramp ) = 'CHICAGO'
That's the minimum time you can get for this query.
>
>>That's true. Please see my reply to Alex Wieder.
>>
>>>Dan,
>< SNIP >
I did a select which just did the top select which writes out 27,705 records.
I then did another select which applied the rest of the filters.
This took 31 seconds.