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 -> Couple Questions about Explain Plan

Couple Questions about Explain Plan

From: Ryan Gaffuri <rgaffuri_at_cox.net>
Date: 7 Feb 2003 03:45:32 -0800
Message-ID: <1efdad5b.0302070345.471ff321@posting.google.com> 





    
  
  1.   What is a 'buffer sort'? Didnt see that one explained in the
documentation. My best guess is that its a memory sort when you have
an order by?

  
  2.   'Cartesian Merge Join'. I think I read somewhere that this isnt
always a bad thing and its not always a sign that your joins are
incorrect. Anyone have any more information?



Received on Fri Feb 07 2003 - 05:45:32 CST












Original text of this message













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