Materialized View and the tablespace

From: C Chang <cschang_at_maxinter.net>
Date: Sun, 04 May 2003 23:38:57 -0400
Message-ID: <3EB5DCD1.24A2@maxinter.net>

On my 8.1.6 server, which is on the NT 4 , 2 CPU, 6 HDs (no partition), If I am going to create a materialized view which will includes almost half of my db records, which tablespace is more preferred for it?

1. create its own talbespace
2. TABLESPACE sys_static
3. TABLESPACE sys_dynamic

4 TABLESPACE sys_staging

C Chang Received on Sun May 04 2003 - 22:38:57 CDT