Re: Partitioned or non-partitioned indexes
From: Adam Musch <ahmusch_at_gmail.com>
Date: Mon, 25 Apr 2011 14:33:12 -0500
Message-ID: <BANLkTinv9zXxw1Go8-Z8jLrcwmzgY9B+Sw_at_mail.gmail.com>
300,000 rows is a very small number for partitioning.
Date: Mon, 25 Apr 2011 14:33:12 -0500
Message-ID: <BANLkTinv9zXxw1Go8-Z8jLrcwmzgY9B+Sw_at_mail.gmail.com>
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_at_gmail.com
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Apr 25 2011 - 14:33:12 CDT