hint

Paginating Through a Documentum’s Result Set

This blog article shows examples of the pagination DQL hint RETURN_RANGE.

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(…)

19c: scalable Top-N queries without further hints to the query planner

By Franck Pachot . The FETCH FIRST … ROWS ONLY syntax arrived in Oracle 12c and is much more convenient than using a subquery with ‘ORDER BY’ wrapped in a “WHERE ROWNUM < …” around it. But as I(…)

OCM 12c preparation: Materialized View explain_rewrite

By Franck Pachot . When I passed the OCM 11g exam, I had to prepare the 'Manage Materialized Views to improve rewrite' topic. Now that I'm preparing the 12c upgrade I checked quickly what I've(…)