By taking all the joins out I think they mean basically forcing Oracle to store the row data in the same blocks since you changes the rows to columns or some such. I saw a database out there a while back promoted by Joe Celko called KillerDB that does this but the data is still stored in rows. It was used for very large decision making systems. I can't find the site anymore so perhaps just another .com gone bust.
- Ethan -----Original Message----- Sent: Wednesday, February 27, 2002 12:59 PM To: Multiple recipients of list ORACLE-L I seem to remember reading somewhere that there can be a maximum of 255 columns in a table. Never created a table with half that many before. Dick Goulet ____________________Reply Separator____________________ Author: [EMAIL PROTECTED] Date: 2/27/2002 10:28 AM April, I sincerely hope you're being facetious with the statement that "queries run so much faster if you take all the joins out" 1000 columns!? How many rows like that will fit in a block? Your system has to wade through a lot of extraneous data to get a few columns for a query. How do you index it? You can't. It would be most interesting if you share your benchmarks with us. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan 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).
