Dan,

You don't need

        Not Empty( Ramp ) And ;
        <b>Not</b> Empty( HourCount ) ;

because it's covered by

        Upper( Ramp ) = 'CHICAGO' And ;
        Between( HourCount, 37, 48 ) And ;

Also expression Empty(Somefield) isn't rushmore optimizable. Use Somefield = Space(nn) instead.

>I have six conditions in my where clause.
>Upper( Ramp ) returns 27,705
>Between( HourCount, 37, 48 ) returns 147,711
>Upper( Vendor ) returns 555,784
>Not Empty( Ramp ) returns 957,731
>Not Empty( HourCount ) returns 957,731
>
>The table has 1,166,384 records.
>I have an index on Upper( Vendor )
>I have an index on Upper( Ramp )
>I have an index on HourCount.
>
>I do not have an index on Empty( Ramp )
>I do not have an index on Empty( HourCount )
>
>I am using variables but the with the above example the SQL looks like:
>

>Select ;
>        Ramp, ;
>        Vendor, ;
>        VendCity, ;
>        VendSt, ;
>        HourCount ;
>    Where ;
>        Upper( Ramp ) = 'CHICAGO' And ;
>        Between( HourCount, 37, 48 ) And ;
>        Upper( Vendor ) = 'NIKE' And ;
>        Not Empty( Ramp ) And ;
>        Empty( HourCount ) ;
>    Into Cursor qVendorTimes NoFilter
>

>
>I'm afraid to break the SQL down into multiple SQL's because writing out 27,000 records is going to be slow.
>
>Please help me.
>
>TIA