Checking table index consistency

[Former Member]

Hi Gurus,

I wanted to know to check the table consistency(for indexes) and how to find out how do they differ from the previous versions.

Thanks,

Mike

[abdul_hakim]

hi jo,

welcome to SDN.

You could use <b>utilities->database object->check in SE11</b> for checking the consistency of your table including indexes.

for tracking the versions use <b>utilities->version->version management in SE11.</b>

Cheers,

Abdul Hakim

Mark all useful answers..

[Former Member]

thanks abdul,

i am working on 4.7 and we are upgarding to ECC 5.0, i see some tables in FI modules(5.0) have extra indexes and also a message like "index does not exist in database system ORACLE" what does it refer to.

thanks,

jo.

[RichHeilman]

It seems that SAP is suggesting new indexes without actually activating them. You may activate them from there, and in doing so, will create them in the database.

You might want to check any notes on the subject before doing so, just in case.

Regards

Rich Heilman

[abdul_hakim]

hi jo,

new versions of tables will be delivered in each release.

so while upgrading u need to use the tranasctio SPAD for importing the changes from prev release.

>>"index does not exist in database system ORACLE" means indexes have not been created in your database.in such case u need to activate the table.also use the path which i have given above for checking the consistency of your table.Also check with your BASIS if problem still persists..

Cheers,

Abdul Hakim

[Former Member]

Thanks for the replies.

[Former Member]

Hi,

I have a question , If i active the index it will cause any major problem to database , because already the database table having very large amount of data, so it will take long time to arrange the table entries in the order of the index .