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.
Dave Snyder — — source: Informix-list mailing list archive (1991-1998)
In article <HgPvkq4b9F56075yn@kcbbs.gen.nz> you write:
} We have a little column (CHAR(2)) in a table of about 800 rows.
} There are about 6 different values in the column.
}
} People here (who pay me money) reckon I should create an index on it
} that looks like this:
}
} So: CREATE INDEX myindex ON mytable (little_column, other_uniqueish_column)
}
} Not: CREATE INDEX myindex ON mytable (little_column)
}
} Their logic states that one should add some other columns into the
} index so that the B-Tree isn't filled with lots of duplicate records.
}
} Is this sensible? Anybody else heard this theory before? JL?
}
No matter how ridiculous a request, if the person that pays you money wants
you to do it their way... YOU DO IT! In this particular case, they are 100%
correct in their decision.
DAS
--
Dave Snyder @ Snide Computer Services - Folcroft, PA Current Release
is db4glgen-3.21
UUCP: ..!uunet!das13!dave INTERNET: dave@das13.snide.com
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.