Thank you for taking take to read my question.
We have a live J2EE application using Oracle 8i. Now we are doing v2 to add some modules. We found it has a frequently changing column (status_code) as part of the composite primary keys in some major tables. We know it can cause future proformance issues, however, our application is small and may only have a few thousand records in these major tables. Is it necessary to get ride of status_code from the primary keys? How many records in a table will cause performance problems if it has a frequently changing partial primary key?
Thank you very much,
November 2, 2005 9:27 AM
December 12, 2005 4:34 PM