On Sun, Oct 27, 2002 at 12:46:39PM +0200, Ben-Nes Michael wrote:
> Hi
>
> I add an Index to table that have only 30 rows.
...
> does the planner knows that the table is small and it will take more time to
> check the index then stright check ?
Yes.
> by the way, the table will get quite big in the future.
So add a few thousand more rows and try again. Don't forget to ANALYZE.
--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/
> There are 10 kinds of people in the world, those that can do binary
> arithmetic and those that can't.