Re: Optimizing a BaaN installation
Based on that look at every session doing more than 10,000 reads.
Do onstat -g ses <session-id> and try to catch what sql they are
running
and which database they are in when they run it.
Then do
- dbaccess <database name>
- Run query
set explain on;
Run query
SELECT --+AVOID_EXECUTE,EXPLAIN....
Check the Informix manual for the optimizer hint to avoid
executing the query and to generate explain plans for the query.
- look at sqexplain.out file created in current directory.
Any scans of large tables that should be using indexes?