Home » RDBMS Server » Server Administration » Performance Issue - Statistics included
Performance Issue - Statistics included [message #53602] Tue, 01 October 2002 06:09 Go to next message
Mike Oakes
Messages: 25
Registered: December 2000
Junior Member
Hello, Based on the following statistics when running a sql query using a UNION statment, can anyone offer some changes to parameters or things I can look at.

Statistics
----------------------------------------------------------
0 recursive calls
1568 db block gets
95427 consistent gets
371 physical reads
0 redo size
29009 bytes sent via SQL*Net to client
2053 bytes received via SQL*Net from client
56 SQL*Net roundtrips to/from client
4 sorts (memory)
0 sorts (disk)
391 rows processed

Report message to a moderator

Use UNION ALL instead of UNION [message #53605 is a reply to message #53602] Tue, 01 October 2002 07:05 Go to previous message
Mike
Messages: 417
Registered: September 1998
Senior Member
it would be better if you could put all your information in the same forum

http://www.orafaq.net/msgboard/sql/messages/16226.htm

Report message to a moderator

Previous Topic: partitioned table not working as expected
Next Topic: database link problem
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Sep 27 17:57:58 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.