RE: [sqr-users] Optimizer goal

["George Jansen" <GJANSEN@aflcio.org>]

Last time I checked, the point of diminishing returns was well under 1000, 
probably under 100. All the buffering you can do will not render slow SQL 
blazing fast. Talk to your DBA if there are speed problems.


>>> Ganesh.Muralidhar@honeywell.com 06/02/06 10:52 AM >>>
Thanks. I sorry I typed wrong 

I tried -B1000 itself and does it can used to improve performance
tunning of the SQR.



-----Original Message-----
From: sqr-users-bounces+ganesh.muralidhar=honeywell.com@sqrug.org 
[mailto:sqr-users-bounces+ganesh.muralidhar=honeywell.com@sqrug.org] On
Behalf Of George Jansen
Sent: Friday, June 02, 2006 8:16 PM
To: sqr-users@sqrug.org 
Subject: Re: [sqr-users] Optimizer goal

If no ORDER BY is provided on the SELECT, I can imagine that the change
of optimizer settings could cause the rows to be delivered in a
different order. What is the database setting if you run "show
pararameter optimizer_mode" from the SQL*Plus prompt? But though a
change in optimizer mode could affect the order of rows delivered, in
the absence of an ORDER BY that enforces strict ordering, it should not
affect the rowset otherwise.

The B flag would be -B1000, not B-1000.



>>> Ganesh.Muralidhar@honeywell.com 06/02/06 9:03 AM >>>
1) When I used the 

 

Alter Session set Optimizer_goal = CHOOSE before all the SQL statements
in my reporting SQR the report data changed completely. Can any one give
the reason for this.

 

2) when I used the 

 

    Begin-select B-1000

    EMPLID,

    ...

    ....

 

  It gives a compilation error . Oracle 9i is the database for the
peoplesoft. What is the reason

 

 

Regards

Ganesh A.M

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org 
http://www.sqrug.org/mailman/listinfo/sqr-users 


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org 
http://www.sqrug.org/mailman/listinfo/sqr-users 

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org 
http://www.sqrug.org/mailman/listinfo/sqr-users


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users