Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Tam Mclaughlin — — source: Informix-list mailing list archive (1991-1998)
Some of our tables have 12, 14 , 16 or more indexes on them. I have always
being told and belived that too many indexes and indexes of the wrong kind
can slow queries down i.e. indexes can take up loads of disk space and can
become skewed etc .... Unfortunately, I cant find much info in the informix
manuals to support this in detail. Can anyone refer me to another manual or
source of information where I can find out more about indexes and
performance.
Thanks.
Your privacy choices
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.