Hi.
This is a second attempt. My first Email never got
posted.
I have the following query:
select a1.MBR_TYP_CDE MBR_TYP_CDE,
(COUNT ( DISTINCT a1.NOVS_NTWRK_MBR_KYD ))
DISTINCTALLMERCHCO
from MDSS_STAR.NOVUS_NETWRK_MBR_D a1
group by a1.MBR_TYP_CDE
The explain plan for it is as follows:
Gene,
This is not much help I'm afraid but are the statistics etc on both the old
and new table at the same stage (preferrable both up to date)?.
I've tried to recreate this on NT with no success,
keep me informed.
Dave Leach
-Original Message-
Sent: 06 July 2001 14:36
To: Multiple
Hi all.
I'm having problems with the following query:
select a1.MBR_TYP_CDE MBR_TYP_CDE,
(COUNT ( DISTINCT a1.NOVS_NTWRK_MBR_KYD ))
from MDSS_STAR.NOVUS_NETWRK_MBR_D a1
group by a1.MBR_TYP_CDE
It fails with ora-06000 (parameter 15851). I have
noticed that if I created the new table