RE: slow DSS large dataset query, help

Posted in 1999

a_blonde@mindless.com — Thu, 9 Sep 1999 11:58:14 -0400 (EDT) — source: Informix-list mailing list archive (1991-1998)

---- you wrote: > Instead of doing the "radical" drop of indexes, force a hash join by adding > "+0" to the equijoin criteria: > > 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 ) Sure Dude, but why not use a supported method? Like: select {+USE_HASH(Table_A/BUILD)} A.c1, A.c2, A.c3, C.c1 from Table_A A, Table_B B, Table_C C or whatever. AB ---------------------------------------------------------------- Get your free email from AltaVista at http://altavista.iname.com