Hi guys,
I'm wondering if anyone out there knows the inside workings of the
select FIRST(x) mechanism.
My question is, In a complex select First query with inner joined
tables, does firebird do the required calculation and comparing to
attain the first X num of records, then stop executing and return the
results OR does the required calculation and comparing for ALL records
but only returns the first X??
Any answers or comments are highly appreciated!!