Skip to content

Performance - PL/SQL

Achieving good performance is very important in server business logic. This section provides some useful guidelines and hints.

This section describes commonly known performance issues that can be avoided by applying these relatively simply performance standards. The issues are not sorted by importance. The nature of performance related issues is such that there is no absolute fix that works for all cases. In some cases one of the solutions described below could be the best solution and in another case it could be better to go with some other solution. But if you suspect that the code you write or change, is critical for performance then you should discuss your proposed solution with a technical expert.


Here are some of the potential performance bottlenecks and the recommended solutions to avoid those