Re: Table with 7000 columns?

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. Received on Tue Nov 30 2004 - 04:52:12 CST