Tablespace and tables question

From: David Kilbern <davidk_at_navo.hpc.mil>
Date: 1997/07/24
Message-ID: <33D7B783.237C@navo.hpc.mil>#1/1

What is the best solution in creating tablespaces/tables?

1 tablespace for each table
1 tablespace and multiple tables
multiple tablespaces with multiple tables in each

What are the advantages/disadvantages?

I have about 10 to 15 tables to create with 2/3's of the tables remaining static once the data is ingested. Appreciate any information/experiences.

david

-- 


---------------------------------------------------------------

David Kilbern                  "I believe an intelligent being
davidk_at_navo.hpc.mil             governs everywhere, except for
Database Analyst/DBA            certain parts of New Jersey."
Northrup Grumman  
Stennis Space Center, MS               - Woody Allen (Sleeper)


---------------------------------------------------------------

Received on Thu Jul 24 1997 - 00:00:00 CDT