Re: clustered tables question 10g

  • From: Greg Rahn <greg@xxxxxxxxxxxxxxxxxx>
  • To: ganstadba@xxxxxxxxxxx
  • Date: Wed, 25 Nov 2009 13:27:35 -0800

My advice would be this: get in the lab, make two versions of your
tables (clustered and not) and compare them to each other in a
workload simulation test.  In almost all cases there are pros and cons
to design decisions but I find it extremely difficult to think of
everything even when I think know it inside and out.  I refer to this
as evidence-based design; where you let the performance data decide
what design is best, not something else.

On Wed, Nov 25, 2009 at 11:28 AM, Michael McMullen
<ganstadba@xxxxxxxxxxx> wrote:
> I’m investigating whether it is appropriate to organize some of the tables 
> into clusters,


-- 
Regards,
Greg Rahn
http://structureddata.org
--
//www.freelists.org/webpage/oracle-l


Other related posts: