Received: from merganser.its.uu.se (merganser.its.uu.se [130.238.6.236]) by hub.org (8.9.3/8.9.3) with ESMTP id OAA14564 for ; Sat, 18 Dec 1999 14:01:34 -0500 (EST) (envelope-from peter@localhost.its.uu.se) Received: from regulus.its.uu.se ([130.238.7.19]:62992 "EHLO regulus.its.uu.se") by merganser.its.uu.se with ESMTP id ; Sat, 18 Dec 1999 17:12:14 +0100 Received: from peter (helo=localhost) by regulus.its.uu.se with local-esmtp (Exim 3.02 #2) id 11zMUT-0000Ed-00; Sat, 18 Dec 1999 17:13:53 +0100 Date: Sat, 18 Dec 1999 17:13:53 +0100 (CET) From: Peter Eisentraut To: admin cc: pgsql-sql@postgresql.org Subject: Re: [SQL] making 'like' queries quicker In-Reply-To: Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=ISO-8859-1 Content-Transfer-Encoding: 8BIT Sender: Peter Eisentraut On 1999-12-17, admin mentioned: > Is there a way to make queries using the 'like' operator quicker, more > specifically for queries that look like: > select name from table where name like '%abc%'; These kinds of queries (where the search string starts with a wildcard) never use indexes, so you're stuck with the sequential scan. A faster computer is probably your best option. :( -- Peter Eisentraut Sernanders väg 10:115 peter_e@gmx.net 75262 Uppsala http://yi.org/peter-e/ Sweden