Skip to Content

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

Huge difference in Execution time in same Query with different Parameter

Hi Experts,

We are facing an unique problem once we are executing the query in HANA SQL prompt. This Query was generated from BObj and executing in HANA system. Once this query running with following condition, it is taking almost 7-00 minute to execute and returning around 924 rows.

<< WHERE

  (

Table__1."LOGSYS"  IN  ('RKGCLNT102')

AND

Table__1."CompanyCode"  IN  ('7240','7245')

AND

Table__1."Plant"  IN ……………… >

However if we run the same query with some different plant, It is taking only 2 second. Please find the Query here.

<< WHERE

  (

Table__1."LOGSYS"  IN  ('RKGCLNT102')

AND

Table__1."CompanyCode"  IN  ('7245','7600')

AND

Table__1."Plant"  IN ……………… >

This is really an unexpected behavior and we are not able to get the actual reason why it is behaving like this.

Could anyone please help to analyze this issue to fine the root cause.

Thanks in Advance.

Regards

Satrajit.

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