Tom,

Make sure you SET DELETED OFF then before running the SELECT

>and there are NO deleted records. Actually you will see other problems when
>using a deleted() tag such as when browsing a very large table for the first
>time. I know that without it the SYS(3054) will not show full optimization but
>that is the price you pay...