-
Type:
Bug
-
Resolution: Fixed
-
Priority:
Medium
-
Affects Version/s: 2.9, 2.10
-
Component/s: None
We have one index on the ATTACHMENTDATA table called attch_data_idx. But this index only covers the ATTACHMENTID column. But the only query apart from primary key queries we run against that table uses the ATTACHMENTID and the ATTVERSION as a selection criteria. This query will not use the single column index and we therefore need compound index which includes ATTACHMENTID and ATTVERSION.