Walter Meester
HoogkarspelNetherlands
General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>If SET DELETED is ON, you need an index on Deleted() on both table for a full optimization.
Yeah, and will probately slower than partial optimization. The deleted(0 tag should not be used. Especially on table with no or just a few deleted records.
Just see the discussions held the past few months regarding the deleted() tag.
Walter,
Previous
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