James,

Do a sys(3054,11) call prior to running the selects and see what it tells you.

>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.