topic general in Application Development and Automation Discussions

general

Former Member — Sat, 05 May 2007 06:08:25 GMT

if we create secondary indices then how we have to write select statement for it ?plz reply to me .

Re: general

Former Member — Sat, 05 May 2007 06:11:20 GMT

hi,

Refer

http://help.sap.com/saphelp_47x200/helpdata/en/cf/21eb20446011d189700000e8322d00/frameset.htm

<b>Create</b>

http://help.sap.com/saphelp_47x200/helpdata/en/cf/21eb20446011d189700000e8322d00/frameset.htm

Regards,

Santosh

Re: general

Former Member — Sat, 05 May 2007 06:12:54 GMT

Hi Manjula,

Basically index are provided to improver performance. i.e with index select on db tables retrieves data much faster.

If you are writting select statement on the table where in where clause you have non-primary keys then it takes longer to retriev data from DB table.

If you have select in dbtable on non-primary key you can create Secondary index with keys as per your where clause which result in faster DB table access.

Thanks.

Re: general

amit_khare — Sat, 05 May 2007 06:13:14 GMT

Check the threads-

Regards,

Amit

Reward all helpful replies.

P.S. try to give more meaningful subject lines.

Re: general

Former Member — Sat, 05 May 2007 06:13:15 GMT

index ?

u have to use all the fields on which u have created index.

like this

in my index fields are---

bwart

werks

charg

so my select stmt will be

select * from mseg into corresponding fields of i_mseg

where

bwart eq '101' and

werks eq 'pp01' and

chard ne ' '.

regards

Prabhu