Received: from pcr.ca (www.pcr.ca [207.139.158.13] (may be forged)) by hub.org (8.9.3/8.9.3) with ESMTP id OAA23295 for ; Sat, 18 Dec 1999 14:53:29 -0500 (EST) (envelope-from admin@wtbwts.com) Received: by pcr.ca (Postfix, from userid 1000) id 0B28D1F43; Sat, 18 Dec 1999 14:52:21 +0000 (GMT) Received: from localhost (localhost [127.0.0.1]) by pcr.ca (Postfix) with ESMTP id EB0411F1F; Sat, 18 Dec 1999 14:52:21 +0000 (GMT) Date: Sat, 18 Dec 1999 14:52:21 +0000 (GMT) From: admin X-Sender: admin@server.b0x.com To: Peter Eisentraut 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=US-ASCII Whatabout queries which only end with a wildcard? is there any way to accelerate such a query? > > 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. :(