Re: Oracle Row size

Faheem's right: Oracle can cope. I think the question he's implying is: "Can your users?" And, to help them do so, you have some design thinking to do.

I'm not so sure that clustered indexes are the only (or even the best) approach but, how you implement a large table depends on the nature of the data. (Note also that how large this table is depends on the row length as well as number of rows: if each row is only, say, 20 bytes, then you may not have too much trouble anyway.)

If most of your data is inactive and you only tend to access the tail of the table, think about partitioning of one form or another. If you are going to be performing low-cardinality selects, you certainly do need to think about indexes - but, if the size implies high volumes of inserts, there may be a trade-off needed here.

Len

>I am designing our database model for oracle and one of my tables will
>potentially be having more than around 192000000 rows. Do you think
>oracle could handles this ?
>
>Thanks in advance.
>
>Sachin.
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Sat Dec 02 2000 - 11:57:36 CST