Thursday, December 27, 2007

Transmittal database problems

Transmittal database performance problems:

1. Missing constraints.
2. Doc_change_status function "S" status query taking long time. Solved by adding a Hint.

3. Database was never analyzed. Analyzed now.

No comments: