query performance problem for like opeartor.

Hi ,

We have  problems in  below query,

Hence this query is going for full tablescan becuase of the portion and taking along time to execute.

AND d.apar_id LIKE '61375110' in the query.

To improve the query performance we thought to change the query but this is the business requirement and we cannot change query.

So can you please suggest without changing the query can we avoid the full tablescan and improve the performance.

Please find the below query.

"SELECT d.apar_id, d.voucher_date, d.remitt_id, d.cur_amount, d.payment_id,

d.pmt_seq_no, d.voucher_no, d.sequence_no, d.ext_inv_ref,