Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: select with "like" from another table
- From: "chris smith" <dmagick(at)gmail(dot)com>
- To: "Anton Maksimenkov" <anton200(at)gmail(dot)com>
- Cc: pgsql-performance(at)postgresql(dot)org
- Subject: Re: select with "like" from another table
- Date: Mon, 29 May 2006 20:36:43 +1000
On 5/29/06, Anton Maksimenkov <anton200(at)gmail(dot)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/
- Follow-Ups:
- Re: select with "like" from another table
- From: Anton Maksimenkov
- Re: select with "like" from another table
- References:
- select with "like" from another table
- From: Anton Maksimenkov
- select with "like" from another table
- Prev by Date: select with "like" from another table
- Next by Date: Re: Getting even more insert performance (250m+rows/day)
- Previous by thread: select with "like" from another table
- Next by thread: Re: select with "like" from another table
- Indexes: