I have the same problem like you Rajesh, the query also gives different
rowcount each time executed eventhough there's no one updating base
tables, in my opinion it's because of the sorting operation (your group
by clause). In my case after I remove some group functions, the result
goes well. Also
If what you are describing is completely accurate,
( no DML, change S_A_S fixes the problem ) then
it would appear you have encountered a bug.
A search on MetaLink is in order, and failing that,
you need to open a TAR.
Jared
On Thu, 2004-01-29 at 04:59, Wendry wrote:
I have the same problem
Hi
Jared,
Thanks for your response.
different results mean that number of records are different sometimes, and
sometimes the some of the quantities are not correct. Your help is really
appreciated.
Thanks,
Rajesh
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL
]
Sent: Tuesday, January 27, 2004 2:29 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: UNION ALL Query: Riddle
Q: What does different results mean?
Different row count?
Completely different data
Q: What does different results mean?
Different row count?
Completely different data?
Partially different data?
Some columns have incorrect value?
What about doing it without the parallel hints? The tables aren't
so big that it would take a long time to find out.
Jared
Pillai, Rajesh