Re: Couple Questions about Explain Plan

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Sun, 09 Feb 2003 11:45:47 +0800
Message-ID: <3E45CEEB.392F@yahoo.com>

Ryan Gaffuri wrote:
>
> 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?

'buffer sort' I'm pretty sure has come into play only since 9i. But the anomaly of things not appearing in the doco until many, many months, years after the function appears in the code is a common thing with Oracle :-(

cheers
connor Received on Sat Feb 08 2003 - 21:45:47 CST