Re: One source of constant annoyance identified

From: "P(dot)J(dot) \"Josh\" Rovero" <rovero(at)sonalysts(dot)com>
To: "P(dot)J(dot) \"Josh\" Rovero" <rovero(at)sonalysts(dot)com>
Cc: Markus Wollny <Markus(dot)Wollny(at)computec(dot)de>, pgsql-general(at)postgresql(dot)org
Subject: Re: One source of constant annoyance identified
Date: 2002-06-28 13:13:59
Message-ID: 3D1C6117.6020109@sonalysts.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Should have said:

"leading % forces a sequential scan". Sorry

P.J. \"Josh\" Rovero wrote:
> LIKE '%dfjdsklfdfjdklfjds' is what is killing you.
>
> LIKE 'sdfdklf%' can be indexed, but the leading wildcard
> forces an index search.
>

--
P. J. "Josh" Rovero Sonalysts, Inc.
Email: rovero(at)sonalysts(dot)com www.sonalysts.com 215 Parkway North
Work: (860)326-3671 or 442-4355 Waterford CT 06385
***********************************************************************

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Markus Wollny 2002-06-28 13:16:16 FTI: help /w compiling/installation wanted (Full Text Index)
Previous Message Michael Meskes 2002-06-28 13:13:14 Re: ecpg help