Does anyone have an idea on how to predict the number of file that might get tiered? I used
select count(*) from backups where (cast (day(current_timestamp-backup_date) as decimal) >= 30) and it turns out that the number of files is much larger when the tiering processes are running. Regards, Joerg Pohlmann
