If you index with FOR NOT DELETED(), it won't help. This tag will be ignored by Rushmore. Index on DELETED() and make sure to SET DELETED OFF before running the query.
=================
<i><font color="#663300">Hi Graeme,
I don't have access to such a large table, but my thoughts would be to check if the sql is being optimized have you a index/filter for Not Deleted() = .T. for example. This may explain.
Just a thought!
--------
Craig Berntson
©2001 Craig Berntson |
