On Sun, 3 Sept 2023 at 23:52, veem v wrote:
> Additionally, is it true that optimizer will also get fooled on getting the
> math correct during cardinality estimates, as because there is a big
> difference between , comparing or substracting, two date values VS two number
> values. And storing
Thank you so much for the clarification.
Actually team have used similar partitioning strategy on integer columns in
past. So they are inclined towards that. I will still, double check with
others if any business restrictions exists. But as you already mentioned,
it's not good in terms of data qua
Have your friends also mentioned how it is going to help to convert date
field to integer !???
On Sun, Sep 3, 2023 at 3:51 AM Erik Wienhold wrote:
> On 03/09/2023 00:35 CEST veem v wrote:
>
> > We are trying to create a monthly range partition table , partitioned on
> > column PART_DATE. This w
On 03/09/2023 00:35 CEST veem v wrote:
> We are trying to create a monthly range partition table , partitioned on
> column PART_DATE. This will hold Orders and part_date is nothing but invoice
> date. Some Team mates are asking to use the "PART_DATE" column as data type
> "INTEGER" with "MM"
Hello Friends,
We are trying to create a monthly range partition table , partitioned on
column PART_DATE. This will hold Orders and part_date is nothing but
invoice date. Some Team mates are asking to use the "PART_DATE" column as
data type "INTEGER" with "MM" format and also define partitions
