Skip to Content
0
Former Member
Aug 21, 2008 at 02:23 PM

Problem with the table FAGLFLEXA

91 Views

Hi,

I have a process in BW that execute a SQL statement in PBP using the table FAGLFLEXA but the execute process is very, very slow.... So, I try to create a index in the table but I see that exist another one created by SAP with the same fields without one field (PRCTR) that I need.

I don''t know if is recomendable create another index with the same fields, adding the field missing.

i.e.

Index created by SAP:

RCLNT
RLDNR
RBUKRS
RACCT
RYEAR
POPER

Index created by me:

RCLNT
RLDNR
RBUKRS
RACCT
RYEAR
POPER
*PRCTR*

This is the SQL statement that I have problems:
                                                                                SELECT                                                                                "HSL" , "POPER"                                                          FROM                                                                                
"FAGLFLEXA"                                                                
WHERE                                                                           
  "RCLNT" = :A0 AND "RLDNR" = :A1 AND "RBUKRS" = :A2 AND "RACCT" = :A3 AND "RYEAR" = :A4 AND "POPER" < 
  :A5 AND "PRCTR" = :A6#

What you recommend?

Thanks a lot for the help!