Query on IBt1 is very slow

[douglas_marroquin]

Hello everybody,

I am trying execute this query, " Select Itemname, BaseNum, Bactchnum, Quantity, Baseentry from IBT1 where itemcode = '49004' and batchnum ='412016-300' "but the response time is very long, approximately 15 minutes resulting 10 lines, occasionally SQL show this error: "a severe error ocurred on the current command"

when I run a select count (*) the result is 25 minutes the result is: 12,829,699 records.

Do you have an Idea, for this?

SAP 9.1 PL PL13

SQL 2012 PL 3

DB size 60 GB.

Thank you for your help.

[douglas_marroquin · Accepted solution]

Thank you Nagarajan K,

I tried your recommendation, the time of response is better than the first query, but the performance is not efficient yet.

I applied these notes:

1868964 and 1455278

the performance is optimized 100 %

[kothandaraman_nagarajan]

Hi,

Filter using base type to get list of transactions for selected item code and batch number. May be more transactions for selected item code and batch number.

Regards,

Nagarajan