Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: primary key width limit, why, can it be overriden
In article <3772B357.6BB273D5_at_home.com>, khanf_at_home.com 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.
>b. what is the limit on Sun Solaris
>c. How to override this limit
>
>Thanks in advance.
>Furkan Khan
If you actually need more than that in a primary key, I would sincerely question the design!
If you're wanting to "cover" a query of a wide table, consider index-only tables (Oracle8).