Re: Re: Stranger than fiction - EXPLAIN results

Fran Fabrizio <ffabrizio(at)exchange(dot)webmd(dot)net> writes:

> Seq Scan on status s (cost=0.00..9.04 rows=1 width=84)
>
> 010502.11:24:05.003 [3029] CommitTransactionCommand
>
> Which is incorrect because it should be using my index, shouldn't
> it? Here is how I created my index:

If a table is small (you have ~200 rows in it, right?) a sequential
scan will usually win even when there is an index. Enjoy your
improved query time and be happy. ;)

-Doug
--
The rain man gave me two cures; he said jump right in,
The first was Texas medicine--the second was just railroad gin,
And like a fool I mixed them, and it strangled up my mind,
Now people just get uglier, and I got no sense of time... --Dylan