why are you doing this?This isn't anything that you would want to do in the real world. What is the actual scenario that you are trying?
On Thu, Feb 12, 2009 at 11:33 AM, Chucara <[email protected]> wrote: > > Ayende: Are you saying I should do this instead: > > select pc, chld from PROJ_COMP as pc > left outer join fetch pc.Children as chld > where pc.PROJ_NO = 147 and pc.PARENT_PROJ_COMP_NO is null > > I will try this. > > Data size is: 10,000 parent components, 10 subcomponents each. (It's > basically a stress test) >
