code for select statement using secondary index

[Former Member]

hii all,

Please provide me

code for select statement using secondary index ?

thanks

rahul

[Former Member]

Hello

Simply encount of the field in such order, in what they are located in index. Only this fields will be used.

[former_member125931]

Hi,

Craete Index for desired table with limited fields(take 5 max) then write below code in select statement after the where condition.

%_hints oracle 'INDEX("MSEG" "MSEG~ZMS")'.here MSEG is table ZMS is its index.

[Former Member]

Hi,

Check this link:

http://help.sap.com/saphelp_nwpi71/helpdata/en/cf/21eb2d446011d189700000e8322d00/content.htm

Regards

Adil