SQL Performance (MOSC)

MOSC Banner

QUERY WITH SQL CONNECT BY WITH 150 ROWS (((((( NEVER END ))))

in SQL Performance (MOSC) 3 commentsAnswered ✓

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

/

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center