OPTIMIZE FOR 1 ROWS

Hi List...
We are currently working through some performance issues in our ERP system. One thing that our DBA has pointed out is that on all select statements that are being executed against the database, they all end in with "OPTIMIZE FOR 1 ROWS".

He has pointed out that this may be a source of pain if most of our reports do selects on tables that return more than 1 row. I remember a number of years ago; that I ran across an INI setting that would disable this in JDE.

Anyone, have any experience with manipulating this setting? Is there any benefit to turning this off?

Tim,

what exactly is the ini setting syntax?

Larry,
That's the problem. I don't remember what the setting was. It seems like it was a setting that went in the ini file. However, I cannot find anything on it.

Thanks
Tim