Home » SQL & PL/SQL » SQL & PL/SQL » Is there a limitation of connect by for Partitioned tables (Oracle 11g)
Is there a limitation of connect by for Partitioned tables [message #643957] Fri, 23 October 2015 12:07 Go to next message
gentleman777us
Messages: 122
Registered: April 2005
Senior Member
Hi,

Iam running a hierarchical query to get its parent, children etc by using connect by start with operators.

Iam running this query against a partitioned table, the query only returns partial results, is there a restriction/bug for connect by operator when ran against partitioned table to return only partial results?

Thanks

Report message to a moderator

Re: Is there a limitation of connect by for Partitioned tables [message #643958 is a reply to message #643957] Fri, 23 October 2015 12:15 Go to previous message
Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator

No theoretical restrictions but optimizer bugs maybe.

Report message to a moderator

Previous Topic: Need answer for below block
Next Topic: Compare values based on range
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Jul 15 11:11:18 CDT 2026
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.