onconfig

Hi there. I am an Oracle/Sybase dba. I've just been put on a project which uses Informix Workgroup Server V7.12 on Windows NT. I have no training or manuals in either Informix or NT, so this question may appear to come from a simpleton. I issue a select * from tablename. The table has 8000 rows in it. The response time is in the region of 5 -10 minutes. Now, I know a table scan will be done but the response is obviously not acceptable. I've managed to find a ONCONFIG file which, I believe contains the database tuning paramters. How can I tell if this is the file being used? Does anyone have any idea where I can find the startup script to validate the db config file name? They are having serious response time problems on a development application using fairly complicated SQL but until I get past this basic problem (architectural/tuning), I won't look at the complicated stuff. Let's get the simple things going first. Thanks in advance to anyone who can help me out. Sue