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.