Hi Sergey,

>>>>I'd like to speed up my sql select statement and have tried everything I could think of to make it "Rushmore" optimized, to no avail.
>>>>
>>>>Here are two sql's, the first is slow, the second is fast.
>>>>
>>>>
>>>>***5,323 records in 40.03 secs.
>>>>select dam1, yr_bred, name, sex, sire1, booked_to, last_bred, p_b, date_foal, date_died, cause_deat, ;
>>>>price_sold, buy_name, age_rec, life_earn, cl from master where category = "F" and type = "S" or ;
>>>>type = "W" or type = "Y" order by dam1 into table foals nofilter
>>
>> Use optimizable function INLIST instead of or condition, if number of types <=24 (Inlist is limited by 24 codes).
>>Is there an index on TYPE?
>>
>>
>Or better of use native SQL operator IN
>where category = "F" AND type IN ("S", "W", "Y")

I had some negative experience with IN function. I already discussed this problem in some threads about 2 months ago... Try to find them, if you're interested...