Re: tuning informix 7.1

: I have to do some tuning on a informix 7.1 OnLine database running on : a Siemens RM600. : Normally I would use the "SET EXPLAIN" function, but ... : The database is only accessed through MsAccess and ... : only on views. : Anybody has a Idea I can use, knows about some tool or something else : that might be of help??? Since you're on 7.1, you can run onstat -g ses or onstat -g sql on the server and see what SQL statement is being executed, then execute it from DB-Access with SET EXPLAIN turned on. Just an idea. June ---- June Tong Informix Software ---- ---- Senior Consultant (415) 926-6140 ---- ---- International Support junet@informix.com ---- ---- Location-du-jour: Taipei, Taiwan ----