Re: how to get index scan at work?

Hi Thomas,

it did not work for me!

tradein_clients=> explain SELECT email_id from email_bank where email
ILIKE 'mallah(at)grex(dot)org';
NOTICE: QUERY PLAN:
Seq Scan on email_bank (cost=0.00..22926.16 rows=1 width=4)
EXPLAIN
tradein_clients=> explain SELECT email_id from email_bank where email =
'mallah(at)grex(dot)org';
NOTICE: QUERY PLAN:
Index Scan using email_bank_case_insen on email_bank (cost=0.00..4.83
rows=1 width=4)
EXPLAIN
tradein_clients=>

btw i could not create the index the way you suggested

regds

tradein_clients=> CREATE UNIQUE INDEX email_bank_case_insen on
LOWER(email_bank(email));
ERROR: DefineIndex: relation "lower" not found
tradein_clients=>