I have actually read 1410160.1 before - it doesn't really answer my questions. What is the science behind setting these options and will they affect the peformance of the report?
For example the db fetch size default is 500 they recommend setting it to 20 if you hit out of memory options - thats a BIG difference! What is this actually doing during processing
I am in situation where I'm 90% sure these options have been set on incorrectly and what to know if there would be any benefits from removing them.