Re: primary key width limit, why, can it be overriden

From: Darren Brock <brock_at_governet.net>
Date: Thu, 24 Jun 1999 16:56:05 -0600
Message-ID: <3772B784.8833E360@governet.net>

Furkan Khan wrote:

> Folks, does anyone know why there is a limit
> on how wide the primary key (including any
> candidate keys) can be.
>
> Does any one know:
> a. the reason for this limit.

It probably has to do with space and speed. Primary keys are indexed and having enormous keys on there probably just doesn't make index them worth the trouble, not to mention all the space the indexes would consume.

>
> b. what is the limit on Sun Solaris

I think it's 1500 chars total, includes combination keys, total.

>
> c. How to override this limit

I don't know but if I had to guess it would be a database configuration parameter

>
>
> Thanks in advance.
> Furkan Khan

Darren

Received on Thu Jun 24 1999 - 17:56:05 CDT