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.