Patch Number

Ticket Number

Change Type

PN5_20460

N/A

Patch

1. Description

SQL: Fix issues with indexing

Fix issue of index being dropped when IS NOT NULL is used.

Currently IS NULL will still resort to full file scan as there is no way to guarantee that NULL has not been excluded from an index.

1.1. Previous Release Behavior

Indexes where dropped when IS NOT NULL was used.

1.2. Current Release Behavior

Indexes should now be used used under these conditions.