Postgres Pro
Downloads
Home   >   mailing lists

Re: is it possible to get the optimizer to use indexes - Mailing list pgsql-performance

From Christopher Kings-Lynne
Subject Re: is it possible to get the optimizer to use indexes
Date
Msg-id 3FE256AA.8000707@familyhealth.com.au
Whole thread Raw
In response to is it possible to get the optimizer to use indexes with a like clause  (Dave Cramer <pg@fastcrypt.com>)
Responses Re: is it possible to get the optimizer to use indexes
List pgsql-performance
Tree view 
> It appears that the optimizer only uses indexes for = clause?

The optimizer will used indexes for LIKE clauses, so long as the clause
is a prefix search, eg:

SELECT * FROM test WHERE a LIKE 'prf%';

Chris

pgsql-performance by date:

Previous
From: Dave Cramer
Date:
Subject: is it possible to get the optimizer to use indexes with a like clause
Next
From: Dave Cramer
Date:
Subject: Re: is it possible to get the optimizer to use indexes