Skip to content

Can we really OPTIMIZE FOR LAST ROWS in SELECT statements? #214

Closed
@mrotteveel

Description

@mrotteveel

Discussed in FirebirdSQL/firebird#8419

Originally posted by Wolf-SO January 31, 2025
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?

Metadata

Metadata

Assignees

Labels

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions