Re: select query not using index

am  Sat, dem 02.12.2006, um 16:35:47 +0530 mailte vivek@staff.ownmail.com folgendes:
>
> The index was created before the table was populated. There are 3 rows
> in the table for 3 different users. Now when I do a

In this case, with only 3 rows, it is much cheaper to do a seq-scan
instead a index-scan, because a index-scan must read the index first and
then the table. And in your case, with only 3 rows, the engine needs
only one page to read.



Andreas
--
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47215,   D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   http://wwwkeys.de.pgp.net