topic Re: index in Application Development and Automation Discussions

index

Former Member — Tue, 05 Dec 2006 08:29:03 GMT

hi,

i had totally 1 lac of records in my ztable ,i picking those records by using where clause with primary key but that table having only one p.key that i used,

but also iam not able to improve the performance, for that wat i have to do

need some clarifications regarding this ,

for that i create secondary index one of the field in the ztable and how to use this seconday index in my select query and how to create secondary index.

pls claify this.

Thanks

Rams

Re: index

Former Member — Tue, 05 Dec 2006 08:35:10 GMT

Have a look at below link for procedure of creating secondary indexes:

<a href="http://help.sap.com/saphelp_nw2004s/helpdata/en/cf/21eb47446011d189700000e8322d00/content.htm">Creating Seconadry Indexes</a>

Also have a look at below link which will show you how to use the same effectively in SELECT statement.

<a href="http://help.sap.com/saphelp_nw2004s/helpdata/en/cf/21eb2d446011d189700000e8322d00/content.htm">How to use secondary indexes</a>

I hope it helps.

Best Regards,

Vibha

<b>

*Please mark all the helpful answers</b>

Re: index

sreekanthgo — Tue, 05 Dec 2006 14:16:37 GMT

Hi Rams,

Are you selecting data in a single shot or are you using SELECT.. ENDSELECT..

One way that you can do is, use SELECT * INTO TABLE ITAB where primarykey = XYZ.

Check the below links to get the help on SECONDARY INDEX.

Thanks,

Sreekanth

Re: index

Former Member — Tue, 05 Dec 2006 21:22:36 GMT

if you want to create secondary index for your table - please check all programs where this table is used to buld index which can be useful for different programs, you may add some more fields or put them into order which will suit most of the programs.

The index is used by DB automatically, AFTER reorg/runstats on DB.

Re: index

Former Member — Thu, 07 Dec 2006 09:13:57 GMT

Hi Rams,

Your Z table has only one field as primary key and you are using that key in the where clause. The database automatically creates an index on the primary key. So there is no requirement of creating a secondary index. Your primary index would be used in your select query.

If you are using Select *, it might help if you specify the fields that you are using in your program instead of picking all fields of your table.

Also in case you are using Select-Endselect it would be better to instead pick up all the data in one shot in an internal table and then loop at that internal table to process each record.

Try this and see if your performance improves.

Regards,

Saurabh

Re: index

Former Member — Wed, 13 Dec 2006 03:33:08 GMT

Hi ram,

First we need to know how you have coded.There are lot of ways to improve the performance.You have mentioned already you are accesing the table by primary key .No problem.

Paste your code first