Re: OnLine 7.13 performance problems - comments please?

Posted in 1997

Hans-Eric Sandstrom — 2 Apr 1997 13:51:35 GMT — source: Informix-list mailing list archive (1991-1998)

I notice a lots of seqscans. You probably have to ta a look at the application. Your database probably needs some more indexes. Use set explain on. And watch out for SEQUENTIAL SCANS. Then take a look at the where clause and add new indexed as needed. Have you done update statistiocs. And how many disks do you use. NUMAIOVPS = #disks.