Re: Partitioned or non-partitioned indexes

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: