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.
Albert wisse — — source: Informix-list mailing list archive (1991-1998)
<HTML>
What is the speed difference on selects like select * from table where
key = 'ksks......kjljf;qlfk" when the key on which selected is of
size:
<P>a) varchar[16]
<BR>b) varchar[32]
<BR>c) varchar[64]
<P>The key is indexed so the select uses the index to find the table row(s).
<P>Does it depens on the word size of the CPU and/or how many registers
a CPU has.
<BR>I am using a SUN Enterprise server with four UltraSparc II CPU's.
<P>Regards,
<P>Albert Wisse.</HTML>
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.