Re: In Statement Help

2004-08-03 Thread Martin Gainty
Indexed- Martin Gainty From: Michael Stassen <[EMAIL PROTECTED]> To: Martin Gainty <[EMAIL PROTECTED]> CC: [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: In Statement Help Date: Tue, 03 Aug 2004 10:26:29 -0400 MIME-Version: 1.0 Received: from out011

Re: In Statement Help

2004-08-03 Thread Jochem van Dieten
On Tue, 03 Aug 2004 06:50:46 -0600, Martin Gainty wrote: > > Keep in mind that when you use LIKE you will NOT use an index but you will > use a full table scan instead > Also instead of using IN EXISTS uses Indexes on the master table query..if > you have master-heavy or parent-heavy query use EXI

Re: In Statement Help

2004-08-03 Thread Michael Stassen
Martin Gainty wrote: Andrew et al- Keep in mind that when you use LIKE you will NOT use an index but you will use a full table scan instead. Agreed. Also instead of using IN EXISTS uses Indexes on the master table query..if you have master-heavy or parent-heavy query use EXISTS/NOT EXISTS vs IN/

Re: In Statement Help

2004-08-03 Thread Michael Stassen
w Dixon wrote: Hi. Thanks Stephen, the works like a dream... Unlike this database which is more like a nightmare!!! Best Regards Andrew. -----Original Message- From: Stephen E. Bacher [mailto:[EMAIL PROTECTED] Sent: 03 August 2004 12:16 To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: In S

RE: In Statement Help

2004-08-03 Thread Martin Gainty
://archives.postgresql.org/pgsql-performance/2002-12/msg00185.php HTH, Martin Gainty From: "Andrew Dixon" <[EMAIL PROTECTED]> To: "'Stephen E. Bacher'" <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]> Subject: RE: In Statement Help Date: Tue, 3 Aug 2004 12:27:25 +0100

RE: In Statement Help

2004-08-03 Thread Andrew Dixon
Hi. Thanks Stephen, the works like a dream... Unlike this database which is more like a nightmare!!! Best Regards Andrew. -Original Message- From: Stephen E. Bacher [mailto:[EMAIL PROTECTED] Sent: 03 August 2004 12:16 To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: In Statement

Re: In Statement Help

2004-08-03 Thread Stephen E. Bacher
Andrew Dixon <[EMAIL PROTECTED]> wrote: >Hi Everyone. > >I require some help with an IN statement I'm trying to get working. I have >inherited a database from someone else in which there is a table with >project information and a field containing which geographic regions the >projects relate. As a

RE: In Statement Help

2004-08-03 Thread Andrew Dixon
Hi Rhino I had pretty much already suggested doing that, but I have been told that I'm not allowed to redesign the database as there is already lots other code working on it already that would need changing as well. I personally think the database design is terrible, but I have to work with what I

Re: In Statement Help

2004-08-02 Thread Rhino
- Original Message - From: "Andrew Dixon" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, August 02, 2004 9:44 AM Subject: In Statement Help > Hi Everyone. > > I require some help with an IN statement I'm trying to get working. I have >

In Statement Help

2004-08-02 Thread Andrew Dixon
Hi Everyone. I require some help with an IN statement I'm trying to get working. I have inherited a database from someone else in which there is a table with project information and a field containing which geographic regions the projects relate. As a single project can relate to multiple geograph