Hi Dan,
>I think I've finally found the answer. This Select is actually a drill down from another summary table. I've managed to pre-digest the table so that each drilldown corresponds to a single value which I place in a one character field called RampCode. I've simplified somewhat, but basically, using Walter's COPY idea the final code looks like this.
>
>
>
>Select RampDrillDown
>Set Order To RampCode
>Seek "1"
>
>COPY FIELDS Ramp, Vendor, VendCity, VendSt, HourCount ;
> TO tRampDrillDown ;
> WHILE RampCode="1" NoOptimize
>
>
>
>The NoOptimize is the key. Without the NoOptimize, this same COPY takes about 20 to 25 seconds. In this case, for whatever reason, optimization fails.
I'm afraid, i don't understand. The WHILE clause should prevent optimization at forehand so adding the NOOPTIMIZE clause should not make a difference. How long does it take with the NOOPTIMIZE clause. Please give me more information about your solution; I'd really like to know whats going on here.
Walter,