Re: How to enhance Performance and fine tune a database

Posted in 1998

KPonn — 31 Jan 1998 17:13:14 GMT — source: Informix-list mailing list archive (1991-1998)

>and fine tune the database.Both databases are created in the rootdb >>space. You should never keep anything in rootdb space. Leave this area for Informix (sysmaster database etc...). Preparing your SQL statements will greatly improve performance. Run set explain on your queries. Fragmentaion (depending on the data) will help (in most cases) if you have multiple CPUs >There is a good book available called "Informix Performance Tuning" which >should cover most of your needs. Read this book.