Hi All,
Below is the setup in my system for AG.
AG setup :-
Multiple load per Table
10M rows Per segment
Segment Field is Date_processed
Expiration type Is LOAD
Data to be archived for 7 Years
Data expected is 150K per cycle.
1) Will having single table for all load give better performance in CMOD then splitting table with 10 Million? or it will be same if we retrive document just by index field.
I assumed segmented table will improve performance as request goes directly into particular table.
2) Is document expiration days are counted from the day doc has archived when we set expiration as LOAD? or it depend on sgment table date.
