Todd Brasseur wrote:

>
> We are very happy with how quick our application is and we think that
> one of the reasons it is quick is because of the single integer primary
> keys.
>
> Will moving to 2 part primary keys affect the speed of our queries?

No, or rather, almost not at all. If the first part of the key is the
server identifier and is, say, a two byte character field, then it will
add only two bytes to each index page - which is almost nothing. The
comparison of index keys is done bytewise, skipping compressed prefixes,
so that won't be affected.

Regards,


Ann