Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: [PERFORM] temporary indexes
- From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
- To: "Jim C. Nasby" <jnasby(at)pervasive(dot)com>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
- Cc: <pgsql-hackers(at)postgresql(dot)org>,<pgsql-performance(at)postgresql(dot)org>
- Subject: Re: [PERFORM] temporary indexes
- Date: Tue, 28 Feb 2006 11:55:32 -0600
>>> On Tue, Feb 28, 2006 at 11:36 am, in message <440435BC(dot)EE98(dot)0025(dot)0(at)wicourts(dot)gov>, "Kevin Grittner" > Also, EXISTS works in situations where > you need to compare on multiple columns, so it is useful in many > situations where EXISTS or MIN/MAX techniques just don't work. Sorry. That should have read: EXISTS works in situations where you need to compare on multiple columns, so it is useful in many situations where IN or MIN/MAX techniques just don't work.
- Follow-Ups:
- Re: [PERFORM] temporary indexes
- From: Tom Lane
- Re: [PERFORM] temporary indexes
- References:
- temporary indexes
- From: Kevin Grittner
- Re: temporary indexes
- From: Jim C. Nasby
- Re: [PERFORM] temporary indexes
- From: Tom Lane
- Re: [PERFORM] temporary indexes
- From: Kevin Grittner
- temporary indexes
- Prev by Date: Re: Dead Space Map
- Next by Date: Re: Dead Space Map
- Previous by thread: Re: [PERFORM] temporary indexes
- Next by thread: Re: [PERFORM] temporary indexes
- Indexes: