AD-XP experiences ?

Posted in 1999

JVA — Wed, 10 Nov 1999 23:10:22 +0100 — source: Informix-list mailing list archive (1991-1998)

I'm running a DSS db with a classical star schema, and a typical "group by" request gets 10 times slower when adding the sixth label table (50 rows only) ... The doc says AD-XP module can help thanks to the "semi-hash join". Any positive or negative experience ? Thanks, Jean

↪ replying to JVA

JVA — Sun, 21 Nov 1999 23:26:22 +0100 — source: Informix-list mailing list archive (1991-1998)

opt_goal did the job ... JVA a 'crit dans le message <80cq7i$ape$1@wanadoo.fr>... >I'm running a DSS db with a classical star schema, and a typical "group by" >request gets 10 times slower when adding the sixth label table (50 rows >only) ... The doc says AD-XP module can help thanks to the "semi-hash join". >Any positive or negative experience ? > >Thanks, >Jean > >