Last week when tuning some query with a CONNECT BY clause in a correlated sub-query and reading it’s execution plan i discovered some strange things.Here is quick test case to demonstrate the findings :
TEST CASE :
Last week when tuning some query with a CONNECT BY clause in a correlated sub-query and reading it’s execution plan i discovered some strange things.Here is quick test case to demonstrate the findings :
TEST CASE :