Brian Wisniewski wrote: The will be querying off of customer id, check number, etc but theycannot guarantee the combination of customer and check or various othercolumns will be a unique row so the need for a sequence. The columnsthat would normally make up the PK are ALMOST always unique but once ina while ... This data is coming from banks - how accurate can it be? :)Once they receive the rows back that match the query they will then doa second select using the rowid returned from the first select to pullback the specific images.- Brian--- "Gogala, Mladen" wrote:> 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 Messag! ! e-----> 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 > > - Brian> > __________________________________________________> Get personalized email addresses from Yahoo! Mail - only $35 > a year! http://personal.mail.yahoo.com/> -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com> -- > Author: Brian Wisniewski> INET: brian_wisniewski@yahoo.com> > 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: L! ! istGuru@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).> -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com> -- > Author: Gogala, Mladen> INET: MGogala@oxhp.com> > 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@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 H! ! ELP command for other information (like subscribing).__________________________________________________Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Brian WisniewskiINET: brian_wisniewski@yahoo.comFat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing Lists--------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail messageto: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).Do You Yahoo!? - Get personalized email addresses from Yahoo! Mail Personal Address - only $35 a year!