>>I did break it down in to more than one sql but that didn't work either.
>
>You are saying that just doing this part:
>
>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" into...
>
>still gives a None level, when you have an index on category?

Bruce,

You're right, I looked at my cdx and realized that the index tag was combined (category + type), not individual.

As soon as I added two separate tags, one for category and one for type and ran the same sql the results appeared in 1/4 the time (10 seconds instead of 40), and the sys(3054,11) returned full optimization.

Now I know the tags need to be individualized to the where clause.

Thanks to everyone,

Jim Harvey
jharvey@netrax.net