Guidelines for optimizing query performance for the table-structured file wrapper
You can improve the performance of table structured file queries by having files that are sorted and by creating statistics for your nicknames.
Use the following tips to improve query performance:
- Sort the data in your files. The federated server can search files that are sorted much more efficiently than files that are not sorted.
- For sorted files, specify a value or range for the key column when you submit a query.
- Statistics for nicknames of table-structured files must be updated manually by updating the SYSSTAT and SYSCAT views. Use the Nickname statistics update facility to update the statistics for the table-structured file nicknames.