>Some documentation (hackers guide) say dat including a tag on
>deleted() records in a table increase performance in SQL select queries.
>
>However in Foxpro Advisor there was an article that it can also slow down queries.
>
>Has anyone tested this,
>
>Please advise
There have been a number of threads here that show that if you do not have a large number of deleted records, then this can actually slow a query down dramatically.
There was one user who tracked the existence of a DELETED() tag to a prblem where a query was taking over 2 minutes with it and 5 seconds without for a large table.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao