On 5/29/06, Anton Maksimenkov <anton200@xxxxxxxxx> 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/
