Performance on 7.30

Please give me your input on this problem. Problem: I have an sql that runs in 5.34 minutes on an AIX and 18.30 on an HP. This is with no user PDQPRIORITY set. If I set PDQPRIORITY=2 (or greater), the HP is faster, 1.07 vs 3.03. I expected the HP to be faster in both cases. Question: Does anyone have an idea why the slower AIX box is outrunning the HP when PDQPRIORITY is not set? I have a feeling it may be related to the way the optimizer works with 7.30, but have been unable to prove it. Information: o AIX: AIX 6000 4.2.1, 6 cpu's, 768mb mem, Informix 7.24.uc5 o HP: HP 9000/800 10.20, 5 cpu's, 2gb mem, Informix 7.30.uc2 o Update statistics were ran on both. o The only difference in the ONCONFIGS is one less cpu on HP, but do not expect this to be a factor if PDQ is not used. o The fragmentation is the same on both. o I see no I/O bottlenecks, nor any CPU bottlenecks. o Query: SELECT a.cust_id, c.cust_nm, c.sls_rep_id, c.nam c.l_umb_custg_repid, c.h_umb_custg_repid c.addr_line_2, c.cntry_id, c.city, c.sta c.phone_nbr, c.act_cd, c.cust_typ_descr, a.bill_to_cust_id, a.bill_to_cust_nm, a. a.cred_rep_nm, a.sched_col, a.col, a.ori a.oride_start_date, a.oride_end_date, a. a.credit_stat_desc, c.prv_sls_rep_id, c. c.prv_l_umb_custg_id, c.prv_h_umb_custg_ FROM cust_dim c, acct_dim a WHERE 140000 > c.sls_rep_id AND a.cust_id = c.cust_id AND c.act_cd = 'A' o Sqexplain.out for AIX: Estimated Cost: 159142 Estimated # of Rows Returned: 62600 yateshe1.c: SEQUENTIAL SCAN (Serial, fragments: ALL) Filters: (yateshe1.c.sls_rep_id < 140000 AND yateshe1.c.act_cd = 'A' ) yateshe1.a: SEQUENTIAL SCAN (Serial, fragments: ALL) DYNAMIC HASH JOIN Dynamic Hash Filters: yateshe1.c.cust_id = yateshe1.a.cust_id o Sqexplain.out for HP: Estimated Cost: 260284 Estimated # of Rows Returned: 61679 root.a: SEQUENTIAL SCAN (Serial, fragments: ALL) root.c: SEQUENTIAL SCAN (Serial, fragments: ALL) Filters: (root.c.sls_rep_id < 140000 AND root.c.act_cd = 'A' ) DYNAMIC HASH JOIN (Build Outer) Dynamic Hash Filters: root.a.cust_id = root.c.cust_id Herbert Yates Database Administrator Herbert.yates@cibavision.novartis.com (770)418-3322