Walter Meester
HoogkarspelNetherlands
General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>then call the Time To Run Query = t, and
>let's say x% of the records are deleted.
>With indexing on deleted, performance will improve by:
>Time To Run Query = .01 * (100-x) * t
Simular rules also should apply to normal indexed fields for example:
If a table contains a sex field where the value could be "M" or "F" this field can be compared with the deleted() mark of a record.
IOW the optimizer makes no distiction between the deleted mark or a regular field. Therefor following queries should be the same:
SET DELETE ON
SELECT * FROM Table INTO CURSOR x NOFILTER
AND
SET DELETE OFF
SELECT * FROM Table WHERE DELETED() INTO CURSOR x NOFILTER
It takes not much imagination to see that this would be a simular query to:
SELECT * FROM Table WHERE Sex="M" INTO CURSOR x NOFILTER
where a index exists on Sex
Regards,
Walter
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only