on 08-21-2008 5:19 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
95 | |
11 | |
11 | |
10 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.