Here is the way to measure informix cost factor.
set explain on;
select * from table
- Use set explain on; before your sql stetement in telnet client in dbaccess mode in informix.
- Then exit dbaccess mode and type "ls -ltrh" in your home directory.
- This will list all the files. Go to end. You will find a file called as "sqexplain.out".
- Vi the file. Then press "shift+g" to end of the file to see your table cost factor details.