The designer should have thought the performance of the system even before creating a table. Now it is too late. Most of D/W systems are built in this fashion.
However, if you understand the application and the business logic, you can rewrite the code. A tough task ahead.

Good Luck
Tamil