having the sample tables:
CREATE TABLE GENERIC (OID VARCHAR(64) NOT NULL, SUBCLASS VARCHAR(64), PRIMARY KEY (OID))
//
CREATE TABLE PERSON(OID VARCHAR(64) NOT NULL, NAME VARCHAR(128), ADDRESS VARCHAR(256), PRIMARY KEY (OID))
//
ALTER TABLE PERSON ADD FOREIGN KEY(OID) REFERENCES GENERIC(OID)
//
CREATE TABLE PRODUCT(OID VARCHAR(64) NOT NULL, NAME VARCHAR(128), ESPECIFICATION VARCHAR(256), PRIMARY KEY (OID))
//
ALTER TABLE PRODUCT ADD FOREIGN KEY(OID) REFERENCES GENERIC(OID)
//
CREATE TABLE PART(OID VARCHAR(64) NOT NULL, PART_NUMBER VARCHAR(64), PRIMARY KEY (OID))
//
ALTER TABLE PART ADD FOREIGN KEY(OID) REFERENCES PRODUCT(OID)
//
Since all transactions need insert in GENERIC table too, what is the performance issues with this model?
Best regard's
Cl�vis
_______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
