Mike Yearwood
Toronto, Ontario, Canada
General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Hi Jim
Further, it would be much faster to SET DELETED OFF than to INDEX ON DELETED() TAG on a large table ;)
>>>Torgny,
>>>
>>>I don't know if (SQL) BETWEEN is optimizable. Apparently, BETWEEN() (the function) *is*.
>>
>>Yes, it is.
>
>Good to know. Have you got a reference so that I can write another Documentation note to MS about this being documented in the CORRECT place?
>
>>
>>>If you are running with SET DELETED ON and you do not hav a TAG on DELETED() then partial may be the best you can get BUT... (repeat: BUT) that may well be OK!
>>>
>>>IF your table has few or no deleted records, then running withOUT a TAG on DELETED() is most likely best, because its overhead is very large and can easily outweigh the benefit when there are few records deleted.
>>>
>>You can TEMPORARILY add a TAG for DELETED() and check the optimization level. If it shows FULL then you will know that the cause of the "PARTIAL" was the missing TAG on DELETED() and then you can REMOVE THAT TAG with confidence.
>>
>>Temporary setting SET DELETE OFF will achive the same result.
>
>Don't know why I typically take the harder way, but I usually do. Thanks.
>
>>
>>>
>>
>>< snip>
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