In standard LiveReports, queries are also executed using a “Cursor Fetch” to retrieve one row of data at a time so that Content Server can limit the total number of results returned. This limit can be set via the Record Limit field in both standard LiveReports and LiveReport Extensions. This approach protects the database from inappropriate queries returning excessively large result sets; however, this mode is slower than a standard SQL query (i.e. not Cursor Fetch mode). When queries are being developed and tested it is recommended to leave the Cursor Fetch mode selected and limit result sets with the Record Limit option. Once a query has been debugged and determined to be safe, this mode could be unselected in order to improve query performance. When this option is unselected an alert is generated to warn that the SQL query will now return unlimited results unless some constraints are specifically added to the SQL. For example: RowNum < 1000 in Oracle or TOP 1000 in MS SQL.