Postgres Pro
Downloads
Home   >   mailing lists

Re: why does seq scan instead of index scan - Mailing list pgsql-sql

From Tom Lane
Subject Re: why does seq scan instead of index scan
Date
Msg-id 8294.1295027762@sss.pgh.pa.us
Whole thread Raw
In response to why does seq scan instead of index scan  (中川　誠貴 <nakagawa@ivp.co.jp>)
Responses Re: why does seq scan instead of index scan
List pgsql-sql
Tree view 
中川　誠貴 <nakagawa@ivp.co.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

pgsql-sql by date:

Previous
From: 中川　誠貴
Date:
Subject: why does seq scan instead of index scan
Next
From: 中川　誠貴
Date:
Subject: Re: why does seq scan instead of index scan