Too many key parts specified
Hello:
I'm migrating table that have more than 16 key parts, and i cant created it in Mysql. What should i do? As i understand, i have 2 options:
1. Create an id as identity column, making this column the key for the table, and left the real key outside of the key.
2. Create insert and update trigers that will concatenate all the fields of the key in one field wich would be the key for the table.
Which implementation would you recomend? Or if you have other ideas? Which one would be faster to use with heave selects and other operations?
Thankyou in advance!
Subject
Views
Written By
Posted
Too many key parts specified
12135
June 01, 2007 11:11PM
6461
October 09, 2007 07:00AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.