DD:table index

[Former Member]

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..

[Former Member]

Hi,

At max we can create 9 secondary index.

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

[Former Member]

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

[Former Member]

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 ....

3.

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

Regards,

Santosh

[Former Member]

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).

[Former Member]

Hi,

Regarding SQVI go through this site

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