Change table key

[Fabrício]

Hi all !

I need to change a table key, i have a table with 500.000 entries, today this table is updated 3 and 3 minuts.

See the situation:

today:

field_a key

field_b key

field_c key

field_d

field_e

field_f

In the future:

field_a key

field_b key

field_c ( now it's is a common field )

field_d

field_e

field_f

I need clear this table and stop update before transport request to change key ??? and about the impacts ????

What is more recommended ?

Thanks in advance.

Fabrício

[stefan_koehler · Accepted solution]

Hello Fabrício,

if you want to reduce the key fields, you have to be sure that the combination of field_a and field_b is unique.

SAP is implementing the key fields as an unique index on oracle.

You don't need to clear (i think you mean delete all entries) the table for that.

Regards

Stefan

[Fabrício · Accepted solution]

Stefan, the combination it's ok !

Thanks a lot !