Re: Partition table not support foreign key feature ?
I've seen lots of tables with 7M rows, but not partitioned.
Your PK is only one column, an INT. There is not much advantage in partitioning on such.
Many of your indexes refer to fields that are not in the table??
Consider whether you need "compound indexes".
Subject
Views
Written By
Posted
3160
June 30, 2010 04:41AM
1601
July 01, 2010 11:12PM
2132
July 02, 2010 05:05AM
Re: Partition table not support foreign key feature ?
2087
July 03, 2010 12:35AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.