Re: Re: Stranger than fiction - EXPLAIN results

Fran Fabrizio <ffabrizio@exchange.webmd.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