Improving query performance
Go Up to Working with Queries
Following are steps you can take to improve query execution speed:
- Set the
TIBQuery
component’sUniDirectional
property toTrue
if you do not need to navigate backward through a result set (SQL-92 does not, itself, permit backward navigation through a result set). - Prepare the query before execution. This is especially helpful when you plan to execute a single query several times. You need only prepare the query once, before its first use. For more information about query preparation, see Preparing a query.