Subject Re: [ib-support] Re: Exists versus select first
Author Marcos Vinicius


----- Original Message -----
From: Ann W. Harrison
Sent: Thursday, March 21, 2002 2:48 PM
Subject: Re: [ib-support] Re: Exists versus select first

At 02:24 PM 3/21/2002 -0300, Marcos Vinicius wrote:
>Tanks Ann and Andrew. By the way, speak about keys make I remember another
>question: Integers PKs are faster that varchar PKs? Same to indexes?

Primary keys are just indexes with some special handling, so
the same rules apply. The basic rule on index keys is that
a shorter key is faster than a longer key because more keys
fit on a page in the index. That becomes somewhat more complex
when you consider prefix compression. There's no difference
in length between an index on a long integer that contains
the values 1, 2, 3, 4, 5 and one that contains AAAAAAAA,

Pick values that make sense for your application.


We have answers.

Yahoo! Groups Sponsor

To unsubscribe from this group, send an email to:

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

[Non-text portions of this message have been removed]