Performance Improvement of a select query on a view
I have a select query on view HRVPADIC. This view sits on table HRP1001 and HRPADIC.
The select query is
SELECT * FROM HRVPADIC INTO CORRESPONDING FIELDS OF TABLE p_lt_1001
WHERE PLVAR = p_lv_plvar
AND RELAT = '291'
AND CONTRACT_APPL = p_iv_appl
AND CONTRACT_TYPE = '02'
AND CONTRACT_ID = p_fs_ctrtbuid.
I want to improve the performance of this query.
Field PLVAR and RELAT are one of the primary key fields of the table HRP1001.
Fields CONTRACT_APPL, CONTRACT_TYPE ,CONTRACT_ID are the non key fields of table HRPADIC.
From the application side, I cannot another condition to the query to improve the performance.
What are the different ways from the Database side to improve the performance of this query?
Will creating a secondary index on CONTRACT_APPL, CONTRACT_TYPE ,CONTRACT_ID fields in HRPADIC help to improve the performance of this select query which is on the view? Or are there are any different answers to this problem.
Thanks in Advance,