Hi! All,
I have a table whoose structure is
*COMPANYID NOT NULL NUMBER(20)
*FINANCIALYEAR NOT NULL NUMBER(4)
*TLSDATAPOINTCODE NOT NULL VARCHAR2(20)
QUARTER NUMBER(2)
NUMBERVALUE NUMBER(20,5)
STRINGVALUE VARCHAR2(4000)
DATEVALUE DATE
BOOLEANVALUE NUMBER(1)
CREATEDBY NUMBER
CREATEDDATE DATE
MODIFIEDBY NUMBER
MODIFIEDDATE DATE
MANUALMODIFICATIONFLAG NUMBER(1)
*- PK
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