scalibility of Hierarchical Qeries

From: Oxnard Montalvo <oxnard_at_carolina.rr.com>
Date: Thu, 7 Feb 2008 9:01:39 -0500
Message-ID: <3488308.719021202392899359.JavaMail.root@cdptpa-web12-z02>

ver. 10.2.0.3

We are considering the use of a hierarchy to maintain a history of changes to rows in a table.

If the table gets large (1x10^7) and has (1x10^6) different hierachies (10 changes to the same table) I am wondering how it will scale, and any tips to help it scale.

Thanks
Ox

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Feb 07 2008 - 08:01:39 CST

This message: [ Message body ]
Next message: Mark W. Farnham: "RE: Rapid Log Switching (one more thought)"
Previous message: Jared Still: "Re: Latest edition of the Cary Millsap + Jef Holt book Optimizing Oracle Performance"
Next in thread: Oxnard Montalvo: "Re: scalibility of Hierarchical Qeries"
Maybe reply: Oxnard Montalvo: "Re: scalibility of Hierarchical Qeries"
Maybe reply: Nigel Thomas: "Re: scalibility of Hierarchical Qeries"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message