Walter Meester
HoogkarspelNetherlands
General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
markus,
>> In my testing table of 1.900.000 records i've deleted about 19.000 records
>> and could not find any significant difference with or without the deleted() tag.
>In this case the problem seems to be that the entire statement isn't optimized. Have you tried Sys(3054,1) to see the optimization level?
It was never the goal to reach full optimization. I did just check the influence of the deleted tag in a rushmore optimizable (partual) expression, and it was about none.
This just means that even if you reach full optimization it would run just as fast as the same query but without the index on DELETED()
But for the record, i'll check this.
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