You can improve retrieval performance by modifying the SQL statements and index definitions on the basis of pdvwopt's output result.
Modifying the access path may not always result in improved performance, depending on the data characteristics. When modifying the access path, be sure to evaluate the performance.
For details about performance design with regard to accesses to foreign tables, see the HiRDB External Data Access Version 7 Description and User's Guide.