On Tue, Apr 11, 2006 at 09:52:40AM +0200, hubert depesz lubaczewski wrote: > On 4/10/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> > What I was hoping for was some general insight from the EXPLAIN > > ANALYZE, that maybe extra or different indices would help, or if there > > is some better method for finding one row from 100 million. I realize > > I am asking a vague question which probably can't be solved as > > presented. > > > > hmm .. perhaps you can try to denormalize the table, and then use > multicolumn indices? That's an idea ... I had thought that since my two referenced tables are small in comparison to the third table, that wouldn't be of any use, but I will give it a try. Thanks ... -- ... _._. ._ ._. . _._. ._. ___ .__ ._. . .__. ._ .. ._. Felix Finch: scarecrow repairman & rocket surgeon / [EMAIL PROTECTED] GPG = E987 4493 C860 246C 3B1E 6477 7838 76E9 182E 8151 ITAR license #4933 I've found a solution to Fermat's Last Theorem but I see I've run out of room o ---------------------------(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