scalibility of Hierarchical Qeries

  • From: Oxnard Montalvo <oxnard@xxxxxxxxxxxxxxx>
  • To: Post to FreeList Oracle-L <Oracle-L@xxxxxxxxxxxxx>
  • Date: Thu, 7 Feb 2008 9:01:39 -0500

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

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


Other related posts: