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 Evaluate as sequence option of the XQuery transformation scenario should be used. This option fetches only the first chunk of the result and the user decides if he wants to fetch the next chunk after looking at the first chunk in the Sequence result view.
The Evaluate as sequence option of the XQuery scenario must be selected in the Output tab of the dialog for editing the transformation scenario.
A chunk of the XQuery transformation result is displayed in the Sequence view.