Re: select with "like" from another table - Mailing list pgsql-performance

On 5/29/06, Anton Maksimenkov <anton200@gmail.com> wrote:
> Hi.
>
> I have 2 tables - one with calls numbers and another with calls codes.
> The structure almost like this:
...

How long does this query take?

SELECT code FROM a_voip_codes c, a_voip v where v.called_station_id
like c.code ||
'%' order by code desc limit 1

I wonder if you'll benefit from an index on a_voip(called_station_id)
to speed up this join.

--
Postgresql & php tutorials
http://www.designmagick.com/