I have a table whoose structure is
*COMPANYID NOT NULL NUMBER(20)
*FINANCIALYEAR NOT NULL NUMBER(4)
*TLSDATAPOINTCODE NOT NULL VARCHAR2(20)
The table has 7005892 rows in it currently and it is going to triple in comming 3 months.
I want to partition the table on Financialyear.
1) Can I partition the table with data?
2) What are the pros and cons of partitioning on financialyear which not the left most column of the PK
There Nothing You cannot Do, The problem is HOW.