My application is currently in Production and facing performance issues. As per suggestion, we need to map WORK and History tables to new tables. Till now they are mapped to default PC_WORK and PC_HISTROTY tables. these table have 1 millions records and they should not be archived.
As per suggestion, I have created new tables. Here my question is if I map the work ad history classes to new tables. How can I transfer records from old table to the newly created ones and Do I need to take any other precautions before mapping to new tables. Please let me know.
***Edited by Moderator: Pallavi to update platform capability tags***