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/