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