On Mon, Feb 25, 2008 at 8:45 AM, Matthew <matthew(at)flymine(dot)org> wrote:
> On Fri, 22 Feb 2008, Kynn Jones wrote:
> > Hi. I'm trying to optimize...
> >
> > (Q1) SELECT a1.word, a2.word
> > FROM T a1 JOIN T a2 USING ( zipk )
> > WHERE a1.type = <int1>
> > AND a2.type = <int2>;
>
> Okay, try this:
>
> Create an index on T(type, zipk), and then CLUSTER on that index...
This is just GREAT!!! It fits the problem to a tee.
Many, many thanks!
Also, including zipk in the index is a really nice extra boost. (If you
hadn't mentioned it I would have just settled for clustering only on
type...)
Thanks for that also!
Kynn