Home » RDBMS Server » Server Administration » Re: Please help me. Group by is not working properly..
Re: Please help me. Group by is not working properly.. [message #375154] Tue, 31 July 2001 21:23 Go to next message
Lee
Messages: 56
Registered: May 1999
Member
Hi! Andrew
Thanks a lot.
But after running the Analaysis statement,
the result is still same...
Please help me if you have any other ideea..

Report message to a moderator

Re: Please help me. Group by is not working properly.. [message #375155 is a reply to message #375154] Tue, 31 July 2001 21:39 Go to previous messageGo to next message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
in sqlplus, "set autotrace on" and then execute the statement - compare plans on both systems.

not a solution, but maybe a workaround...
Select /*+rule */ A, B,C
from table_a
Group by A, B, C;

Select /*+full(a) */ A, B,C
from table_a a
Group by A, B, C;

also, analyze table table_a estimate statistics;

If that all fails, check the oracle metalink for known bugs.

Report message to a moderator

Re: Please help me. Group by is not working properly.. [message #375156 is a reply to message #375155] Tue, 31 July 2001 22:00 Go to previous message
/*rule */ is working but
Messages: 1
Registered: July 2001
Junior Member
Hi! Andrew
Really thanks for your help.
if we are using the index information /*rule /
it is working but if we use /*full */,
still it is not working.
But we can't change the source code.
However, thank for your attending for my problems.
I will visit the Metalink
Thanks a lot

Report message to a moderator

Previous Topic: URGENT need performance tip
Next Topic: Partitioning of tables
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jul 05 11:26:06 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.