User Profile

Stop using ISNULL in the generated SQL for query objects to prevent full table scans.


When a filter is added to a query object in SQL, the generated SQL behind the scenes will wrap the field being tested in an ISNULL. The problem with this is it prevents use of any indexes, which in turn means that it will cause a full table scan. This reduces the usefulness of queries on larger t...

Read more...
0 Comments

Read more...
0 Comments

Category: Development (1136)

STATUS DETAILS
Needs Votes