James,
>
>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

Just try indexing the fields category and type. Please tell me what results you've got.

Walter,