Skip to Content
0
Former Member
Nov 07, 2012 at 06:42 PM

secondary index for ztable

69 Views

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.