Re: [GENERAL] Fast join

> Oh, I'm sorry, it was a typo. But believe me, such behaviour is
> persistent notwithstanding any type of qualification. It is, so
> to say, tested and approved. Look at the explanations of Postgres
> of his plan of query on database whose creation I showed you
> earlier (it has two tables of 10000 rows, properly vacuumed):
>
> -=--------------------------------

> adb=>  EXPLAIN  SELECT COUNT(*) FROM atable WHERE atable.cfield = btable.cfield
> AND atable.afield<10;
> NOTICE:  QUERY PLAN:

But your only restriction is < 10.  That is not enough.  Make it = 10,
and I think it will use the index.


--
  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