Skip site navigation (1) Skip section navigation (2)

is it possible to get the optimizer to use indexes with a likeclause

From: Dave Cramer <pg(at)fastcrypt(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: is it possible to get the optimizer to use indexes with a likeclause
Date: 2003-12-18 23:18:48
Message-ID: 1071789528.1629.10.camel@localhost.localdomain (view raw or flat)
Thread:
Lists: pgsql-performance
It appears that the optimizer only uses indexes for = clause? 

Dave


In response to

Responses

pgsql-performance by date

Next:From: Doug McNaughtDate: 2003-12-19 01:38:13
Subject: Re: is it possible to get the optimizer to use indexes
Previous:From: Tom LaneDate: 2003-12-18 19:56:20
Subject: Re: why do optimizer parameters have to be set manually?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group