Total recall / flashback data archive
- How do statistics work on a TR table ? Do you need to run special stats on these tables?
- Does the normal table indexes also work on the historic data?
- How does a partitioned table work with TR? Is the archived data partitioned too?
- If you create a materialized view on a TR table, does it also create all the history on that table?