General comments in line.
Object (0) though is that clustered tables cannot
be partitioned. This could be a severe limitation
on future growth, and add administrative woes as
the database increases in size.
Rebuttal (0) - the database is too small, and the
licence fee too high to cater for
Objection 1) Most Oracle docs recommend: don't store data in
clusters
if it's going to be updated frequently. Updating clustered tables is
bad.
If its being updated, its not a true data warehouse.
Scott Shafer
San Antonio, TX
210-581-6217
-Original Message-
From:
Objection #6) Clusters do not impose a physical sort order upon the data;
they only impose the physical clustering of rows with the same data values
in it's cluster-key columns to reside in the same database blocks. Will the
same cluster-key values be found in the same blocks? Yes. Are they
Not true. Many folks think a data warehouse is read only. There is a
huge difference between being designed to optimize reading and being
read-only...
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, April 25, 2002 2:40 PM
Objection 1)
: Tim Gorman [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, April 25, 2002 4:20 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: single clustered tables
Not true. Many folks think a data warehouse is read only. There is a
huge difference between being designed to optimize reading