| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Primary Keys
Well, how are you going to locate the image you need? If none of the supported data is needed to describe or locate the image, why have the data at all? I'm not quite sure how to answer your question.
-----Original Message-----
Sent: Thursday, February 01, 2001 2:08 PM
To: Multiple recipients of list ORACLE-L
I know this violates the most basic data modeling techniques but tell me what you think.
I'm working on creating a new database which will be fairly small in number of tables ~8 but large in storage size ~4 terabytes with millions of records eventually.
The 3 large tables will hold small images along with supporting data and the only reason I can see to have a primary key is to have a primary key. There is not a natural key for the tables so it would be a sequence which would never be selected against. Given the number of records all I can see it doing is taking up space, increase the time of the imports, generate more redo logs, etc and I can't see the benefits.
There won't be any tables hanging off of these, I won't be using snapshots, replication or anything else I can think of that would require a PK but the voice 'YOU MUST HAVE A PRIMARY KEY' is resounding loudly in my head so I must ask why?
Tell me what you think.
Thanks
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Feb 01 2001 - 14:12:51 CST
 |
 |