topic Re: code for select statement using secondary index in Application Development and Automation Discussions

code for select statement using secondary index

Former Member — Wed, 16 Jul 2008 09:39:21 GMT

hii all,

Please provide me

code for select statement using secondary index ?

thanks

rahul

Former Member — Wed, 16 Jul 2008 09:44:41 GMT

Hello

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

former_member125931 — Wed, 16 Jul 2008 09:50:38 GMT

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 — Wed, 16 Jul 2008 09:53:59 GMT

Hi,

Check this link:

Regards

Adil