Re: Any issues with large database views?

I am very curious.

What kind of data needs this many fields?

randy

clapoint149_at_my-deja.com wrote:
>
> Hello,
>
> I have the need to store records which will consist of several
> hundred but < 1000 fields. My current understanding is that for Oracle
> 8 and above the table column limit is 1000 and for previous versions of
> Oracle's database server the table column limit is 254. However, I
> have heard that even with the newer versions of the database server
> there are still issues with creating/using tables with more than 254
> columns. I personally do not know what these issues might be, nor do I
> know if they actually translate as problems per se. What I am
> wondering, though, is if these issues (whatever they are) also apply to
> large views (with several hundred columns) that join medium-sized
> tables (each with at most about 100 columns), which is how I prefer to
> store/access my large records. My guess is that large views are immune
> since any table problems most likely stem from physical storage design,
> but I do not know for sure. Could someone shed some light on any
> issues related to large database tables and views? Thanks.
>
> Cary
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Mon Nov 01 1999 - 15:51:21 CST