Hi all,
In my ZF001_BASE table, I have the fields MANDT VBELN FKART VKORG VKBUR SPART KUNRG FKDAT MATNR WERKS FKIMG VRKME NETWR WAERK and so on...
I have created secondary index ID1 for WERKS and declared it in my select statement as below
SELECT VBELN
KUNRG
FKDAT
WERKS
BSTKD
ZLRNO
ZLRDATE
ZLOG_CODE
ZLOG_NAME
ZGRNO_CUST
ZGRNO_DT
ZSTATUS
FROM ZF001_BASE
INTO TABLE IT_BASE
FOR ALL ENTRIES IN IT_BSID
WHERE VBELN EQ IT_BSID-AWKEY
%_HINTS ORACLE 'INDEX("ZF001_BASE" "ZF001_BASE~ID1")'.
For how many fields I have to create secondary index? or do I need to create secondary index for the fields that are defined after SELECT keyword?
I am new to this concept. Please help me.
Thanks,
Venkata.