| 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: RE: Manager decrees "his" data warehouse design. Help!
www.kx.com
-----Original Message-----
Sent: Wednesday, February 27, 2002 2:38 PM
To: Multiple recipients of list ORACLE-L
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.
-----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: Jared.Still_at_radisys.com 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: Ethan.Post_at_ps.net
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 Wed Feb 27 2002 - 14:24:04 CST
 |
 |