Can we really OPTIMIZE FOR LAST ROWS in SELECT statements?

[Wolf-SO]

I'm quite familiar with FB 1.0.3 but somehow wish to get up-to-date with the current developments, so I'm currently reading docs.

In the 5.0 documentation, I read about the setting OptimizeForFirstRows that we can opt for optimizing for first rows instead of all rows (which is the default). We also find the documentation of SET OPTIMIZE and OPTIMIZE FOR Clause linked here. Both contain the option FIRST but then diverge on the option ALL and LAST while they link to each other if they would be alternative ways to reach the same goals (on different levels). Could it be that LAST is just a typo in the OPTIMIZE FOR clause?

[aafemt]

Yes, LAST is a typo in the Release Notes. It should be ALL. Language Reference has it right.

[mrotteveel]

Thanks, I fixed it in the release notes for the next 5.0 release (FirebirdSQL/firebird-documentation#214).