query

[Former Member]

created secondary index for

ref_number as z1

ebelp as z2

existing query

select reason_id reason_category

reason_code ref_number ebelp from

zreason_metrics

into table ireason_codes

where ref_number eq dekko-ebeln and

ebelp eq hlp_e1edp01-posex.

proposed to change query

Is this query correct

select reason_id reason_category

reason_code ref_number ebelp from

zreason_metrics

into table ireason_codes

where z1~ref_number eq dekko-ebeln and

z2~ebelp eq hlp_e1edp01-posex.

Pls suggest me

[Former Member]

YOur existing query is correct only.

The proposed query is wrong.

Regards,

ravi

[Former Member]

Hi,

Ur existing query is absolutely right.

the proposed query is wrong

'z1~'used when there is a join between tables.

rgds,

latheesh

[Former Member]

Thanks Ravi,

My doubt is it is performance issue of already existing program , now i need to create a secondary index , i have done it with the four fileds , is there no need of changing the existing query,

to add the secondary index... if needed pls suggest me a query

thanks

raju