10-16-2007 3:07 PM
what are the maximum number of primary keys in a table ?
Both <b>Z</b> table and system table ?
10-16-2007 3:13 PM
hi,
I am not sure if there is a maximum, however it is not advised to create more than something like 6-8, otherwise the database optimazier won't have any idea which one to choose and chances are that won't choose the best avaliable always.
ec
10-16-2007 3:12 PM
We can have max 16 fields in Primary key for a Table.
This is the standard limit in most of the Databases.
ashish
10-16-2007 3:13 PM
hi,
I am not sure if there is a maximum, however it is not advised to create more than something like 6-8, otherwise the database optimazier won't have any idea which one to choose and chances are that won't choose the best avaliable always.
ec
10-16-2007 3:14 PM
Hi
In the sense of Oracle it should be 16.
if u increase more than 16 a big performence issue will raise
avoid more keys on the table and also the indexces...
<b><REMOVED BY MODERATOR></b>
Message was edited by:
Alvaro Tejada Galindo
10-16-2007 3:15 PM
10-16-2007 3:17 PM
One primary key per table regardless of what type of table it is and regardless of what kind of database it is.
(You can have up to 16 fields in primary key.)