Re: [SQL] Re: questions on interpreting the output of explain\

Excellent analysis.  I will find a way to add this into the documenation
somewhere.


> Michael Olivier <molivier@yahoo.com> writes:
> > Can someone explain the details here to me? I guess specific questions
> > are:
> > - - Does hash join mean my acctname indexes are hashed, not btree'd?
> > - - What does index scan mean?
> > - - Nested loop?
>
> OK, I'll take a cut at this.  (I've been studying the Postgres optimizer
> lately, so I know a little bit about this, but I may be wrong about some
> of the details.)


--
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026