Re: Functional Indices

Stephan Szabo wrote:
>> explain select * from titles where lower(title) = 'monde';
>> Seq Scan on titles  (cost=0.00..39392.10 rows=14145 width=44)
>
> How many rows are in titles?  It seems to estimate 14000+
> rows are going to match.  If that's true, sequence scan may
> be a better plan than the index.  Or, perhaps, do you have
> a very common title value that's throwing off the statistics?
>
Hello,

register=# select count(title) from titles;
  count
---------
 1414473
(1 row)

I have solved the probleme by setting enable_seqscan to false and now it
use index, but i don't understand why it choose to do a seq scan.

thanks
Bojnourdi Kaikavous