I'm doing tests with IQ 15.2 for a possible migration
from a different technology but I getting results that
Yesterday when the tables only had the FP indexes, a
simple query with group by joining a fact table and 2
dimensions took only about 300 secs. During the morning we
have created HG indexes on the ID columns, as recommended by
Index_Advisor but the query doesn't resolve, takes too long.
The fact table has more than 5 billion rows.
Doing the query just on the fact table runs ok.
I have taken the plan from the query and it's doing a
nested-loop pushdown but when I forced hash the times were
I have already increased MAX_HASH_ROWS to 3.000.000.000
as it's a big machine.
Any ideas or recommendations? Should I go to IQ 15.3?
Will it use more cpu's per query?
Subject: IQ 15.2 queries slower after creation of indexes (HG)
X-Mailer: WebNews to Mail Gateway v1.1t
Date: 8 Nov 2011 21:52:38 -0800
X-Trace: forums-1-dub 1320817958 10.22.241.41 (8 Nov 2011 21:52:38 -0800)
X-Original-Trace: 8 Nov 2011 21:52:38 -0800, 10.22.241.41
Xref: forums-1-dub sybase.public.iq:4417
Article PK: 246558
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US; rv:126.96.36.199) Gecko/20111103 Thunderbird/3.1.16
Subject: Re: IQ 15.2 queries slower after creation of indexes (HG)
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Date: 21 Nov 2011 06:06:14 -0800
X-Trace: forums-1-dub 1321884374 10.22.241.152 (21 Nov 2011 06:06:14 -0800)
X-Original-Trace: 21 Nov 2011 06:06:14 -0800, vip152.sybase.com
Xref: forums-1-dub sybase.public.iq:4422
Article PK: 246561
Is this a many-to-many join (outer join) situation?