dedicated tablespaces

From: Richard Baines <richardbaines_at_netscape.net>
Date: Tue, 20 Apr 1999 09:27:56 +0100
Message-ID: <371C3A8C.C4E326F1@netscape.net>

Is there any benefit for setting up different tablespaces to store tables that will perform different roles. (using RAID by the way).

We have a database used for general usage, lots of rows added to several

tables and and regular deletions etc. We also have a set of archiving tables which are populated with data from the regular tables once a month, data is then exported from the archive tables, the archive tables

are then truncated until the following archive occurs (standard sort of data archiving set up).

Are there any performance benefits from putting the archive tables in their own tablespace. Is the regular populating of these tables and truncating of these tables adding to disk fragmentation in my main tablespaces.

any experience/assisstance greatly appreciated

Richard Received on Tue Apr 20 1999 - 03:27:56 CDT