Overhead on Keys

Posted in 1992

Naomi Walker — Mon, 17 Feb 92 16:32:27 MST — source: Informix-list mailing list archive (1991-1998)

We have a table that has currently 20k rows (1700 bytes), and two keys. Index one is on field one thru 4. Index two is on field 5. This table will very soon grow to at least 50k rows. I am considering adding another key on field one and five, but am concerned about the overhead of another key, since speed is a real factor in our application. Does anyone know how to compute the overhead for a key? We are running Informix 4.1, on a Pyramid MIS S Server, and primarily using esql/c for all our code. -- Naomi Walker (aka N7FSA) Anasazi Inc. Phoenix, Arizona anasaz!qip.naomi@asuvax.eas.asu.edu Imagine the Universe Beautiful, Just, and Perfect. (Messiahs Handbook) "