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