Skip to Content

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

Performance Tuning Using Index

Hi,

I would like to discuss about the following code.In Below code S_Doc contains 200 Ranges.

-


SELECT blart opbel INTO TABLE tb_dfkkop_bloc

FROM dfkkop

WHERE opbel in s_doc and augbl = space.

-


Time taken for this query is <b>4 sec</b>. so i rewritten the query like below

-


SELECT blart opbel INTO TABLE tb_dfkkop_bloc

FROM dfkkop WHERE augbl = space.

-


since there is a index on AUGBL, Query took less time as <b>1 Sec</b>.

since only fetching is done here i have used delete statement to filter the data as desired.

delete tb_dfkkop_bloc where opbel not in s_doc

Then it was taking more time than the first query as 5 Sec.

Since the data fetching is done in a good manner, can we approch this method for a huge table?

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