Hi All,
I have a table with status column (Active, skipped, completed, failed) etc. It is huge table(above million and half records) and I want to keep a partition on the status column. Now is it wise to keep the partition on the status column since the value changes from one status to another before finally settling to completed.(I have enabled row movement)
Will this have an impact positively on performance or negatively.
The status change is one directional (from active to completed) and happens quickly.
Kindly provide your comments.