It is possible put a table on several datafiles without partitioning.
Of cource, with partitioning it will have more mintainability and
availability.
--
-----------------------------------------------------
Thanks,
Mark
"Jim" <JimboA_at_yahoo.com> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ:
news:Xns908B9572A290Fjimboausenetserverco_at_64.154.60.92...
> >You might want to do some testing then speak to "someone" about what he
> >expects to do with his multi-hundred GB table once it's built. Will it
> >be possible?
> >
> I know what it's for. It's going to be used for Data Mining and will be
> hosted on an NT Server with 300+GB of disk space. They, the users, bought
> Partioning for this server so it will be possible to break this up over a
> number of datafiles.
>
> J
>
Received on Sun Apr 22 2001 - 20:29:39 CDT
