Oh, the theory is definitely back end dependent. It's also dataset/usage dependent.

Even with our pal Rushmore, physically sorting data in a frequently-used sequence simply means there's less disk to traverse to assemble a result set. With another back end, all bets are off. Fine tuning SQL Server and Oracle for every last nit of performance is a black art I leave for others. ;-)

Dan


>Hi, Dan
>I think that theory might be back end dependant. For example, do you know if that will improve performance for VFP as a back end even if the tags present would make the queries rushmore optimizable?
>
>In MS SQL and Oracle, it's a different matter.