Hi
Our scripts automatically add "LIMIT ALL" & "OFFSET 0" to every select query if no values are passed on for these parameters. I remember reading through the mailing list that it's better not to pass them if they are not needed as they add a cost to the query plan. Is this the case, or am i looking at a very minor optimization.
Amitabh
P.S. I haven't checked my query plans to see if there are any actual effect of these keywords as I am still working my way through reading the output of "Explain" ouput.