Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Table with 7000 columns?
Sybase IQ (not ASE) is a very good database for warehousing. Definitely
take a look at it.
http://www.sybase.com/products/databaseservers/sybaseiq
-- Terry Dykstra Canadian Forest Oil Ltd. "Noons" <wizofoz2k_at_yahoo.com.au> wrote in message news:73e20c6c.0411300252.10e64eb6_at_posting.google.com...Received on Tue Nov 30 2004 - 09:37:23 CST
> hopehope_123_at_yahoo.com (utkanbir) wrote in message
news:<f6c90ebe.0411292239.42efe1f2_at_posting.google.com>...
>
> >
> > The main issue is if i create table with 7800 columns inside ( in fact
> > oracle only allows to create table with 1000 columns) , i believe it
> > cant be queried.
>
> Pretty good assumption.
>
> > My basic calculation shows that the average row size of this table
> > will be 160kb. , considering my db_block_size of 16kb. this means 10
> > blocks for 1 row. (The table will have more than 10.000.000 rows) No
> > matter how fast my disk subsystem is , i think the queries against
> > this table will fail. So what can i do?
>
> Use materialised views? With your calculated values as the columns.
> They won't count as "space".
>
> > type of storage technique for instance column based storage ( i heard
> > that sysbase has this feature , dont know the details / purpose..)
>
> Doubt it.