Hi Balaji,
Yes difinitely ou can create secondary index on ODS. As you know ODS is nothing but a transparent table. The index in database table is applicable to ODS. There are 2 kinds of indeces. Priomary and secondary. Primary index is created by system based on the primary key of the table. In case of ODS depending on the key fields( infoobjects). In case you need to create secondary index you must go to ODS maintainence and choose Index folder and right click on it to Create.
Please note index is created to enhance the performance but wrongly defined index has adverse effect on it i.e. decreases the performance. It may enhance perfomance for you but will reduce the performance for other user so need to be very careful. In case you need further information on this please let me know.
cheers,
hi Balaji,
yes, primary index are created by system.
secondary index, for ods you can create with ods maintenance, right click 'indexed' and add infoobject(s). activate ods again.
or use se11, put in table name, and click 'index' and 'new' (blank page icon).
hope this helps.
Hi
http://help.sap.com/saphelp_nw2004s/helpdata/en/cf/21eab8446011d189700000e8322d00/frameset.htm
it may help you
Thanks
REddy
Add a comment