topic Re: query in Application Development and Automation Discussions

query

Former Member — Tue, 22 Aug 2006 15:59:19 GMT

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

Re: query

Former Member — Tue, 22 Aug 2006 16:04:20 GMT

YOur existing query is correct only.

The proposed query is wrong.

Regards,

ravi

Re: query

Former Member — Tue, 22 Aug 2006 16:12:55 GMT

Hi,

Ur existing query is absolutely right.

the proposed query is wrong

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

rgds,

latheesh

Re: query

Former Member — Wed, 23 Aug 2006 05:44:18 GMT

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