how to create indicies on ODS

[Former Member]

hi experts,

how can i create indices on ODS, pl explain step by step procedure

thanks & regards

venkat

[former_member228339]

Hi..

to add ..

Secondary indexes are created only on characteristic that are in the ODS.

You cant drop a key figure, for obvious reasons to create a sec index, make sure you have the right reason for an extra index, as sometimes this may hamper the query runtime http://help.sap.com/saphelp_erp2004/helpdata/en/cf/21eb47446011d189700000e8322d00/frameset.htm A secondary index is any additional index defined on any combination of other fields. This can be set by the user create indexes on ODS tables as well. Right click on ODS -> Chanage. On the right hand side the last option is Indexes. Open that to see if there are any. For selective deletion : right click on ODS->Manage->Contents tab->Selective deletion (button at the end with a trash can on it).

[Former Member]

Hi,

Usually at DSO manage screen you can create index.Make sure that creating index will help you in increasing the performance.

SE13 is the other option, but that is usually restricted to DBAs. For the ODS, you create the index in dev and transport it thru.

Also refer this thread.Its discussed well.

Hope this helps

Regards

Karthik

[former_member188325]

Have you seen this:

Under Indexes, you can create secondary indexes by using the context menu in order to improve the load and query performance of the ODS object. Primary indexes are created automatically by the system.

If the values in the index fields uniquely identify each record in the table, select Unique Index from the dialog box. The description of the indexes is specified by the system. To create a folder for the indexes, choose Continue from the dialog box. Now you can transfer the required key fields into the index folder using Drag&Drop.

You can create a maximum of 16 secondary indexes. These are also transported automatically.

Message was edited by:

muralidhar c

[Former Member]

Hi,

Go to 'Change' the ODS. Under the folder 'Indexes', right click to create index. To specify the characteristics for the index, drag the characteristics from the key fields or data fields into the index.

Hope it helps.

[Former Member]

Hi Venkat,

Select ur ODS--> right click --> Select "Change" -->Right click on "Indexes" --> Select "Creat New indexes".

Regards

Prasad