Problem with the sysmaster database.

Posted in 2005

Jiten Thakkar — Mon, 19 Dec 2005 11:00:33 -0800 — source: Usenet: comp.databases.informix

Hi , Environment : Hardware : Sun4u-Sparc/Ultra O/S : Solaris 8 Informix : 9.30.FC2 ( 64 bit) I have a database with 40,000 tables. The data warehouse application creates new tables to store the information for new products. My problem is the query on SYSMASTER database is very slow. A simple select from syslocks ( select * from syslocks where tabname = <some_table> ) takes 5 minutes. I have run updates statistics on this table. My fact table has 2 million rows and the select for one of the rows comes back immediately. Can somebody suggest how to improve the performance of the SYSMASTER database ? Thanks, Jiten sending to informix-list