how many tablespaces

From: Vissu <vissuyk_at_yahoo.com>
Date: 3 Mar 2004 20:12:44 -0800
Message-ID: <2bedd6a7.0403032012.2899a4a6@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 Received on Wed Mar 03 2004 - 22:12:44 CST