Patch Number

Ticket Number

Change Type

PN5_20458

N/A

Patch

1. Description

Change the way indexes are located from attribute based to dictionary name based, many sites access there data via conversions in attribute 8 of the dictionary, this effectively makes many indexes redundant.

Add mechanism to detect if an index is missing or just did not return any results. Prior to this change if an index search failed, SQL would end up doing a full file scan.

1.1. Previous Release Behavior

Indexes that used the same attribute number would not work all of the time.

1.2. Current Release Behavior

Indexes should now be used providing the same column name as the index is used.