General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Hi David,
That was the point of the article (or at least one of them) - when you have no deleted records you have the worst case (performance-wise) when DELETED is ON *and* you have a key on Deleted().
You can check this out quickly by simply running the SQL with DELETED set OFF to see if there is a difference.
Prior discussions on this led the believers to conclude that one should *test* using a key on Deleted() (assuming DELETED is ON) to verify that the query is otherwise fully optimized but them remove the key for production purposes.
Cheers,
Jim N
>G'day Jim,
>I haven't looked at the article again, you could be right but I'd be surprised. My tables had no deleted records.
>
SNIP
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