Problems trying to optimize queries as the one below:
WITH Tp1 AS (SELECT 1 as COL1 FROM dual),
Tp2 AS (SELECT Tp1.* FROM Tp1)
SELECT Tp3. COL1 FROM Tp2 Tp3
optimizer asks for bind variables even if it is not needed.
On this example the optimizer ask Tp3.COL1 as bind variable, because it can't recognize the column of '*' in Tp2 representing 'COL1'.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center