Now I know that Sage doesn't support the manufacturing part of Sage 200 anymore (Sicon didn't work for us) but we have an issue that mostly seems isolated to works orders that seems to be related to the opening and/or editing of WO's whereas the screen is VERY slow to load. I had seen something somewhere about the WO SQL tables being VERY badly indexed, but I need to know if there is a way to improve this?

Any help would be cool as it takes our Production department a lot longer to do stuff than it should be. This is not server performance or anything like that as every other part of Sage works fine, we have been using the sales and accounts parts of Sage for years. 

Cheers.