Only SEQUENTIAL READ on all the table

[#1]

Hi,

I have a little problem, I see only "Sequential Read" in the SM50, the system is very slow ...

If I made a test between two server,

The KO server :

SQL Statement

-

---

SELECT

"VBELN" , "ERDAT" , "ERZET" , "VBTYP"

FROM

"VBAK"

WHERE

"MANDT" = :A0 AND "ERDAT" BETWEEN :A1 AND :A2 AND ( "VKBUR" = :A3 OR "VKBUR" = :A4 )

Execution Plan

-

---

System: FEP

-

---

Id

Operation

Name

Rows

Bytes

Cost (%CPU)

-

---

0	SELECT STATEMENT		231	8778	23754 (2)
1	FILTER
2	TABLE ACCESS FULL	VBAK	231	8778	23753 (2)

-

---

Predicate Information (identified by operation id):

-

---

1 - filter(:A1<=:A2)

2 - filter("ERDAT">=:A1 AND "ERDAT"<=:A2 AND ("VKBUR"=:A3 OR

"VKBUR"=:A4) AND "MANDT"=:A0)

The OK server :

SQL Statement

-

---

SELECT

"VBELN" , "ERDAT" , "ERZET" , "VBTYP"

FROM

"VBAK"

WHERE

"MANDT" = :A0 AND "ERDAT" BETWEEN :A1 AND :A2 AND ( "VKBUR" = :A3 OR "VKBUR" = :A4 )

Execution Plan

-

---

System: FED

-

---

Id

Operation

Name

Rows

Bytes

Cost (%CPU)

-

---

0	SELECT STATEMENT		106	4028	11225 (1)
1	FILTER
2	TABLE ACCESS BY INDEX ROWID	VBAK	106	4028	11224 (1)
3	INDEX RANGE SCAN	VBAK~AUD	655K		445 (2)

-

---

Predicate Information (identified by operation id):

-

---

1 - filter(:A1<=:A2)

2 - filter("ERDAT">=:A1 AND "ERDAT"<=:A2 AND ("VKBUR"=:A3 OR

"VKBUR"=:A4))

3 - access("MANDT"=:A0)

[Former Member]

Hi,

It is obvious that optimizer is choosing the wrong path. On "System: FEP", optimizer is choosing "Full Access" whereas "System: FED" is reading data by using "VBAK~AUD" index.

Let's investigate the problem step by step. Firstly, check "VBAK~AUD" is exist on "FEP" on table VBAK. Then, check "check update and optimizer statistics" job on DB13.

Best regards,

Orkun Gedik