topic DD:table index in Application Development and Automation Discussions

DD:table index

Former Member — Mon, 19 May 2008 09:33:03 GMT

hi friends,

i have few queries,

1) how many indexes we can create for a table.

2) when do we create secondary index.

3) how to use SQVI ? help me with an example or a link.

thank you..

Re: DD:table index

Former Member — Mon, 19 May 2008 09:37:48 GMT

Hi,

At max we can create 9 secondary index.

We create secondary index, only if we dont find required primary index (table key).

Re: DD:table index

Former Member — Mon, 19 May 2008 09:43:02 GMT

hi swastik,

1) how many primary indexes can we create?

2) my question is , who asks us to create secondary indexes. wheather the client or we ourselves create it.

thank you

Re: DD:table index

Former Member — Mon, 19 May 2008 09:46:06 GMT

hi,

1. We can create up to 9 secondary indexes.

2. Secondary Indexes are createdd when we use non primary key field s in the select statement ....

http://help.sap.com/erp2005_ehp_03/helpdata/EN/d1/44f2b5c7f411d296080000e82de14a/frameset.htm

Regards,

Santosh

Re: DD:table index

Former Member — Mon, 19 May 2008 10:56:36 GMT

hi,

When we do perfomance check,if we find that database performance is poor and when we r not selecting the data from database using full primary key the performance drasticly decreases at that movement to improve performance secondary index has to be created and developer never creates secondary index TL(team lead will create secondary index).

Re: DD:table index

Former Member — Mon, 19 May 2008 11:03:18 GMT

Hi,

Regarding SQVI go through this site

http://www.sapsecurityonline.com/tutorials/r3_sqvi_tutorial.htm