I have a table that has daily partition, partition key is process_date and subpartition key is billing_id
There are already 1 index on this table, the index has partition and subpartition too. Now I want to create a new index, just like the existing one, it should have partition and subpartition.
But how? I know one single sql can't do the work, anyone please provide the logic or give some instructions?