RE: [sqr-users] Optimizer goal

["Ganesh, Muralidhar \(IE10\)" <Ganesh.Muralidhar@honeywell.com>]

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