The OUTPUT EVERY clause permits the regulation of row publication at specific intervals, based either on time or row counts.
This reduces the number of rows that are published.
Interval Timing With OUTPUT EVERY
Use OUTPUT EVERY to limit the number of rows generated by a query and regulate the timing of the output so that the result rows arrive at a predictable interval.
Row Count With OUTPUT EVERY
Use the OUTPUT EVERY clause with a row count. Provides an example of how to apply the OUTPUT EVERY clause to a row count, as well as, the syntax rules for the clause.