Re: how to get index scan at work?

From: Rajesh Kumar Mallah <mallah(at)trade-india(dot)com>
To: Thomas Swan <tswan(at)olemiss(dot)edu>
Cc: PostgResql SQL Mailing List <pgsql-sql(at)postgresql(dot)org>
Subject: Re: how to get index scan at work?
Date: 2002-04-19 16:33:24
Message-ID: 3CC046D4.B7F972A7@trade-india.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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=>

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Stephan Szabo 2002-04-19 17:12:04 Re: how to get index scan at work?
Previous Message Stéphane DEWITTE 2002-04-19 14:39:43 How to log outputs from pl/pgsql into a file ?