Tag Archives: coalesce subquery

Enhanced Subquery Optimizations in Oracle

March 25, 2010 – 23:28

While googling I found a fresh article from Oracle for the VLDB journal: Enhanced Subquery Optimization in Oracle. It primarily discusses subqueries – how Oracle deals with them on optimization and at run-time.

By Timur Akhmadeev | Posted in CBO, Oracle | Also tagged , , , | Comments (0)

COALESCE_SQ

January 18, 2010 – 00:16

There are 19 new hints in Oracle 11.2.0.1: Some of them represents new CBO features (like FACTORIZE_JOIN/NO_FACTORIZE_JOIN). Here I’ll show purpose of COALESCE_SQ hint (NO_COALESCE is it’s inverse).

By Timur Akhmadeev | Posted in CBO, Hints, Oracle | Also tagged , , , | Comments (3)
Follow

Get every new post delivered to your Inbox.

Join 100 other followers