Re: Tablespace Guidelines?

You will definately want to put the indexes in a seperate tablespace. You also want to be sure that those tablespaces are on a different disk than the tablespaces containing the table. One general rule for tablespaces is that tablespace containing like data be kept together. Another view is that tables that are the same size (or are multiples of the same size) be kept together (to reduce fragmentation). Break up your tablespaces into several datafiles and place those datafiles over multiple disks. This will reduce the disk contention for the system. If you can talk you system adminstrator into it, you should "stripe" the datafiles themselves.  However, if you can't then your next best option is the one I previously mentioned. If you are restoring a large table, your system will certainly be slowed down, but it will not lock your users out unless they are trying to access the table you are restoring.

If you need any more help, I'll be glad to talk with you.

Sheilah Scheurich
Information Services
Huntsville Hospital
205-517-8043 x5709 Received on Sun Jun 04 1995 - 00:00:00 CEST