The FNC_GetPhaseEx options give you more control of table phase transitions when developing variable mode table functions. You can use these options to reduce the number of phase transitions required during execution of a table function, thus reducing the number of UDF invocations and improving table function performance.
- P (TBL_PRE_INIT)
- I (TBL_INIT)
- B (TBL_BUILD)
- B EOF (TBL_BUILD signalling EOF, not TBL_BUILD_EOF)
- F (TBL_FINI)
- E (TBL_END)
X is the scale factor of input to output rows.
| Processing Mode | Required Phases | |
|---|---|---|
| Without FNC_GetPhaseEx Options | With FNC_GetPhaseEx Options | |
| 1:1 (one row in : one row out) |
I, B, B EOF, F | B, if the TBL_NEWROW option is set. |
| 1:M (one row in : multiple rows out) |
I, B*X, B EOF, F | B * X, if the TBL_NEWROWEOF option is set. |
| M:1 (multiple rows in : one row out) |
I, B EOF, F | B * X, if the TBL_NEWROW | TBL_LASTROW options are set. |
For example:
In a 1:1 processing mode, use the TBL_NEWROW option to get a new row on every TBL_BUILD call.
FNC_Mode mode = FNC_GetPhaseEx(&thePhase, TBL_NEWROW);
In this case, the function passes through the following phases.
In a 1:M processing mode, use the TBL_NEWROWEOF option to get a new row when EOF is signaled.
FNC_Mode mode = FNC_GetPhaseEx(&thePhase, TBL_NEWROWEOF);
In this case, the function passes through the following phases.
In a M:1 processing mode, you can use:
FNC_Mode mode = FNC_GetPhaseEx(&thePhase, TBL_LASTROW | TBL_NEWROW);
In a combined M:1 and 1:M processing mode, you can use the following that does not pass a new row until EOF:
FNC_Mode mode = FNC_GetPhaseEx(&thePhase, TBL_LASTROW | TBL_NEWROWEOF);
In this case, the function passes through the following phases.
See FNC_GetPhaseEx.