Select with both Firstfast and FirstOnly

Finance and Operations/AX Technical Forum
1

Hi guys,

I have been seeing some queries combining firstfast and firstonly on select queries. (ex. select firstonly firstfast table1)

Does using both really speed up performance?

It just seems redundant to me…

Thanks.

2

FirstOnly and FirstFast has different uses.

Use Firstony when you have to select only one record. This is mostly used in the queries.

Use FirstFast when you have to select many records but want to get first record fastly. Hardly it need in x++ but all the forms using this to get first record fast.