Hi
I was about to partition a large (?) approx 3T of data 2B rows into
partition tables but broken up into YYYYMM ...
Now I have been reading about limiting the number of partitions otherwise
it could slow down the parser.
My reasoning for limiting to YYYYMM was that most of the request would be
monthly based.
Should I be making the partitioning based on YYYY instead and have lots
more indexs.
If I have an index on the timestamp field will it help limiting to YYYYMM ?
A