Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: nested table performance??

Re: nested table performance??

From: <mjbox01_at_gmail.com>
Date: 18 Jan 2006 04:28:35 -0800
Message-ID: <1137587314.957079.222790@g47g2000cwa.googlegroups.com> 





Unnest the table?



Seriously, if the nested table contains hundreds of rows for each row
in the parent your second query is returning hundreds more rows and so
is going to take longer.



Do you want all that data? If it was a separate table it is easier to
not return it if it is not needed.



Why do you want a nested table, what advantages does it give you?
Received on Wed Jan 18 2006 - 06:28:35 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US