OraFAQ Forum: Server Administration » Re: Please help me. Group by is not working properly..

Home » RDBMS Server » Server Administration » Re: Please help me. Group by is not working properly..

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Re: Please help me. Group by is not working properly.. [message #375154]

Tue, 31 July 2001 21:23

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

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

/*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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 24 07:03:58 CST 2024