We gave a partition table having 4 list partitions and more than 2000 sub partitions and the size is 350 GB. When we try to analyze the table it is taking much time (query is running > 150hr) but no result.
So we tried with granurality= PARTITION option and the partition got analyzed but the last_analyzed is still showing the old date for table. Again tried to analyze the whole table with no options but took much time with no result.
Then we tried with granurality= SUBPARTITION option and again qury took much time with no result.
Kindly suggest me how to reflect the LAST_ANALYZED data to latest one o the table?
Thanks in advance.