Does including hashbucket/MOD function in TD13.10 cause any performance issues. I mean if I can use CHAR-PPI in 13.10 over the HASHBUCKET/MOD approach am I likely to see a performance benefit?
Sandesh R Gitte
you will get partition elimination only for equality when using HASHBUCKET.
So CHAR-PPI is the preferred sollution in 13.10.
I have a table with PPI on date column Fill_DT defined as fill_dt BETWEEN '2001-01-01'(DATE) AND '2014-12-31'(DATE) EACH INTERVAL '1' MONTH
Now I want to know who all users accessed partitions of 2008 and below.
I am doing it with dbql object and log table join and then drilling each sql but that realy difficult as the sqls are more than 10000 is there any way around for this.
Can anybody pls reply me.How to check wheather or not data related to particular partition is accessed or not.Is their any table capturing history data with partition ID.
There is not a table or log that captures which partitions are used.
Also, be cautious when looking at the SQL for specific date qualifications because in many cases the partition inclusion/exclusion is done through Dynamic Partition Elimination during joins to reference tables (eg in your case joins through a calendar reference table/heirarchy).
But that make sense to release space for partitions which are not used from long.In my case ppl who are not using partition 2008 and below I want to delete that data and free space(as part of system retirement).
Is there no way to do it.