Skip to Content
0
Jul 18, 2008 at 09:49 AM

index problem RESB

160 Views

Hello

i have the following query :

SELECT

"POSTP" , "PSPEL" , "GPREIS" , "BDMNG" , "WAERS" , "PEINH" , "RSPOS" , "RSNUM"

FROM

"RESB"

WHERE

"MANDT" = :A0 AND "PSPEL" = :A1 AND "POSTP" IN ( :A2 , :A3 ) AND "XLOEK" = :A4#

I have created an index

NONUNIQUE Index RESB~Z04

Column Name #Distinct

MANDT 1

PSPEL 1

POSTP 5

XLOEK 2

Last statistics date 12.07.2008

Analyze Method mple 20.967.515 Rows

Levels of B-Tree 3

I think that something is wrong above all regarding the high analyze method ...the table goes in table access full and it doesn't use the index created. What do you suggest ?

Thanks

Regards

Nicola