plan

Boost dynamic SQL with Plan Guides

Recently a customer asked me to check why a load process from a banking application has so poor performance.In fact this process is extremely slow, between 40 minutes up to more than one hour to load around 240’000 rows.

Oracle DML (DELETE) and the Index Clustering Factor

As a consultant working for customers, I’m often in the situation that I have an answer to a problem, but the recommended solution cannot be implemented due to some restrictions. E.g. the recommendation would be to adjust the code, but(…)