Nonstop Database, HiRDB Version 9 UAP Development Guide
Sometimes the SQL retrieval performance can be improved by obtaining the retrieval results of only the first n rows. The performance improvement can be expected to increase as the number of retrieval result rows decreases.
When the retrieve first n records facility is used, only the first n rows from the beginning of the SQL retrieval results (or after the specified offset of the first row to return has been skipped) are accepted. In this case, the access path selected by the SQL optimization method changes. Consequently, the SQL retrieval performance may improve as described as follows:
To use the retrieve first n records facility, specify LIMIT. For details about LIMIT, see the manual HiRDB Version 9 SQL Reference.
All Rights Reserved. Copyright (C) 2011, Hitachi, Ltd.