RE: slow DSS large dataset query, help

Posted in 1999

Obnoxio The Clown — Thu, 09 Sep 1999 13:57:45 BST — source: Informix-list mailing list archive (1991-1998)

From: William Raper <WilliamR@catmktg.com> > >Instead of doing the "radical" drop of indexes, force a hash join by adding >"+0" to the equijoin criteria: Doesn't this presuppose the data types of the joining columns? :-) > select > A.c1, > A.c2, > A.c3, > C.c1 > from > Table_A A, > Table_B B, > Table_C C > where > month(A.create_timestamp) = 11 and > year(A.create_timestamp) = 1995 and > A.c1 = (B.c1 + 0 )and > B.c2 = (C.c2 + 0 ) and > B.c3 = (C.c3 + 0 ) > > Bill > > > -----Original Message----- > > From: Obnoxio The Clown [SMTP:obnoxio@hotmail.com] > > Sent: Thursday, September 09, 1999 7:02 AM > > To: sjsyau@my-deja.com; informix-list@iiug.org > > Subject: Re: slow DSS large dataset query, help > > > > This might seem like a rather bizarre idea, but try dropping the indexes > > so > > you get a hash join, rather than a nested loop join. ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com