Approach to table partitioning process
Hello,
Have a nice and oxygenated day with a lot of sunshine and green juices.
I am trying to prepare some workflow list for table partitioning process.
We have few ultra tables with lot of rows and very long records.
We try to locate the most consuming SQL clauses which could be affected with partitioning.
We need those SQL clauses for testing on newer partition organization tables and also for setting up the process of logging of imrpovements in performance.
Our entry idea is to separate history data from the actual data.
History data is still needed but frequency of SQL demands are much much lower than SQL demands on actual data.
Have a nice and oxygenated day with a lot of sunshine and green juices.
I am trying to prepare some workflow list for table partitioning process.
We have few ultra tables with lot of rows and very long records.
We try to locate the most consuming SQL clauses which could be affected with partitioning.
We need those SQL clauses for testing on newer partition organization tables and also for setting up the process of logging of imrpovements in performance.
Our entry idea is to separate history data from the actual data.
History data is still needed but frequency of SQL demands are much much lower than SQL demands on actual data.
0