The result of an XQuery executed on a database can be very large and sometimes only a part of the full result is needed. For avoiding the long time necessary for fetching the full result the Present as a sequence option should be selected in the Output tab of the dialog for editing the transformation scenario. This option fetches only the first chunk of the result. Clicking on 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 user 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 where the option can be modified.
A chunk of the XQuery transformation result is displayed in the Sequence view.