QUERY WITH SQL CONNECT BY WITH 150 ROWS (((((( NEVER END ))))
Hello, anybody found that situation ?
12/19/21 Versions
After insert 148 rows , and try to execute querie : running for many days and never end
SELECT MAX(LEVEL) AS NIVEL, TBA.COLUNA_A
FROM TESTEPERFORMANCE TBA
CONNECT BY PRIOR TBA.COLUNA_D = TBA.COLUNA_A AND PRIOR TBA.COLUNA_E = 'A'
START WITH TBA.COLUNA_A = 1033773
GROUP BY TBA.COLUNA_A
ORDER BY TBA.COLUNA_A
/