The result of an XQuery executed on a database can be very large and sometimes only a part of the full result is needed. To avoid the long time necessary for fetching the full result, select the Present as a sequence option in the Output tab of the Edit scenario dialog box. This option fetches only the first chunk of the result. Clicking the More results available label that is displayed at the bottom of the Sequence view fetches the next chunk of results.
The size of a chunk can be set with the option Size limit of Sequence
view. The
XQuery
options button from the More results available label
provides a quick access to this option by opening the
XQuery panel of the Preferences dialog
box where the option can be modified.
A chunk of the XQuery transformation result is displayed in the Sequence view.