DB2 graphic  QMF Version 8

Limiting returned rows

You can specify a limit on the number of rows returned for queries as a performance safeguard. In a production environment, queries might return an unexpectedly large number of rows, which can place an unacceptable load on the database server and the network, as well as slowing response time for the end user.

If you do not know what a safe row limit is for your world, accept the default data set limit of 1000 rows.


Go to the previous page Go to the next page

Downloads | Library | Support | Support Policy | Terms of use | Feedback
Copyright IBM Corporation 1982,2004 Copyright IBM Corporation 1982, 2004
timestamp Last updated: March, 2004