Re: [sqr-users] Optimizer goal

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

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