Hi,
zzflame_agrt_no & bukrs_vf are non-primary fields in the table VBAK.
select vbeln
auart
vkorg
zzflame_agrt_no
bukrs_vf
from vbak
up to 1 rows
into wal_vbeln
where zzflame_agrt_no = '1212121'
and bukrs_vf = ' DE'.
This query is dying. To improve the performance I created a secondary index in the table VBAK which already has 8 indexes and when I created the index it says "Index does not exist in database system ORACLE ".
I selected non-unique index( Index on all DB systems).
1. How do i remove this message "Index does not exist in database system ORACLE "?
2. My query is for just 1 row but is failing. How do i get the query working ?
Thanks
SMS