On 5/29/06, Anton Maksimenkov <[EMAIL PROTECTED]> 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/
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
