Yes, it definitely helps. Thanks. One thing I am not sure how to do is SET DELETED OFF using the OLEDB provider. I'm doing some VBScript/ADO/OLEDB with the VFP7OLEDB driver and using ADO's GetRows() method to get the data from the table and need all the speed I can get. :)

Do you know how to specify SET DELETED OFF or "ignore deleted records" using the OLEDB provider?

Thanks.


>You can receive partical optimization because SET DELETED is ON and you do not have index on DELETED() in your table. SET DELETED OFF and you will see.
>
>GROUP BY is not optimizable at all because it uses the result of query for it instead of source tables with indexes. COUNT(*) and all other aggregate functions - the same. Maybe SQL Server have better logic for this - I do not know, in VFP for sure optimizable parts are only JOIN and WHERE conditions. Well, to sort and group VFP might decide to make a temporary index or similar...
>
>HTH.