it was meant to be "all things to all people" I know WHY they did what they did, what pissed me off was that they used the excuse that ORACLE couldn't handle more than 4 table joins
--- Igor Neyman <[EMAIL PROTECTED]> wrote: > Actually this is true for MS SQL Server: can not handle efficiently > more > than 6 joined tables, at least on 6.5 version. > So, m.b. vendor's product was supposed to run not only on Oracle, but > other > databases as well. > > Igor Neyman, OCP DBA > [EMAIL PROTECTED] > > > ----- Original Message ----- > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Wednesday, March 13, 2002 9:58 AM > > > > oh yes, one more, I got this from a vendor, as an explanation of > why > > they didn't do a lookup table but instead added columns to the row > for > > EVERY possible value in the lookup table: > > > > Oracle doesn't handle joins with more than 4 tables very well > > > > > > > > --- Jonathan Lewis <[EMAIL PROTECTED]> wrote: > > > > > > My next to favourite legends. > > > > > > Small tables don't need to be indexed > > > > > > Small tables are anything 4 blocks or less > > > > > > Oracle copies the entire row into the rollback > > > segment when updating a single column. > > > > > > Oracle copies the entire block into the rollback > > > segment when updating a row. > > > > > > Oracle can only use 5 indexes in a query > > > (though I haven't heard that one much recently) > > > > > > Setting tablespace default pctincrease to 1 reduces > > > fragmentation problems. > > > (but that's going out of fashion too) > > > > > > But I guess you, Jeremiah and Rachel have > > > already got those covered. > > > > > > > > > > > > Jonathan Lewis > > > http://www.jlcomp.demon.co.uk > > > > > > Next Seminar - UK, April 3rd - 5th > > > http://www.jlcomp.demon.co.uk/seminar.html > > > > > > Host to The Co-Operative Oracle Users' FAQ > > > http://www.jlcomp.demon.co.uk/faq/ind_faq.html > > > > > > Author of: > > > Practical Oracle 8i: Building Efficient Databases > > > > > > > > > -----Original Message----- > > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > > > Date: 12 March 2002 22:54 > > > > > > > > > |Everyone, some great ideas.... > > > | > > > |RF > > > | > > > |Robert G. Freeman - Oracle8i OCP > > > |Oracle DBA Technical Lead > > > |CSX Midtier Database Administration > > > > > > > > > -- > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > > -- > > > Author: Jonathan Lewis > > > INET: [EMAIL PROTECTED] > > > > > > 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: [EMAIL PROTECTED] (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). > > > > > > __________________________________________________ > > Do You Yahoo!? > > Try FREE Yahoo! Mail - the world's greatest free email! > > http://mail.yahoo.com/ > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Rachel Carmichael > > INET: [EMAIL PROTECTED] > > > > 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: [EMAIL PROTECTED] (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: Igor Neyman > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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). __________________________________________________ Do You Yahoo!? Try FREE Yahoo! Mail - the world's greatest free email! http://mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
