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!