Re: Partitioned or non-partitioned indexes

  • From: Adam Musch <ahmusch@xxxxxxxxx>
  • To: kcboyes@xxxxxxxxx
  • Date: Mon, 25 Apr 2011 14:33:12 -0500

300,000 rows is a very small number for partitioning.

That said, if you're going to partition the parent table, you should
consider using partition by reference for the child table if you're
using 11g.

http://download.oracle.com/docs/cd/B28359_01/server.111/b32024/part_admin.htm#BAJDDEEC

-- 
Adam Musch
ahmusch@xxxxxxxxx
--
http://www.freelists.org/webpage/oracle-l


Other related posts: