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.
"Ron M. Flannery" — — source: Informix-list mailing list archive (1991-1998)
}> 4) System not using indexes correctly
}>
}> - Have run update statistics medium for all tables, update statistics
}> high on first column of
}> each index and run update statistics low on all other index fields.
}
}I thought "official policy" was USH for first index columns, USM for
}other index columns and USL for the rest.
}
I'm curious as to the current strategy for update stats. I also thought
that the policy was the latter (USM for other idx and USL for rest) but
reading the 7.22 Performance Guide seems to indicate the former strategy.
Does anyone know if the recommendations changed?
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.