Re: why does seq scan instead of index scan

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: 中川　誠貴 <nakagawa(at)ivp(dot)co(dot)jp>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: why does seq scan instead of index scan
Date: 2011-01-14 17:56:02
Message-ID: 8294.1295027762@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

=?iso-2022-jp?B?GyRCQ2ZAbiEhQD81LhsoQg==?= <nakagawa(at)ivp(dot)co(dot)jp> writes:
> I'm trying to use like 'xx%' search on Text[] column.
> I thought it uses index scan. But actually it uses seq scan.

> Why?

Those ANY expressions are not indexable.

regards, tom lane

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message 中川　誠貴 2011-01-15 05:19:34 Re: why does seq scan instead of index scan
Previous Message 中川　誠貴 2011-01-14 08:58:43 why does seq scan instead of index scan