Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Performance Improvement of a select query on a view

Hi Experts,

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,

Raju

Former Member
Not what you were looking for? View more on this topic or Ask a question