"Vissu" <vissuyk_at_yahoo.com> wrote in message
news:2bedd6a7.0403032012.2899a4a6_at_posting.google.com...
> Hi ,
>
> We will have about 50 tables. Some tables will be huge (severel
> million rows) and some are small but most of them will have about a
> million rows. For best performance of the database, how many
> tablespace should I have. I was thinking of using Locally Managed
> tablespaces (uniform extents) for both data and indexes.
>
> Can anyone share some experiences? Any other tips on layout of the
> database will be appreciated. Thanks
>
> Vissu
What version? Use locally managed with auto managed extents and put the
data all in one tablespace.
Jim
Received on Wed Mar 03 2004 - 22:34:59 CST
