Hello Team,
I have this table which has one driving table and then almost 17 tables left joined on this, now because of this the data has kind of replicated and the table size has grown big.
currently its process 37G data. I would like to tune this table badly. But we don't have any dates or int column to which i can create partition on. any suggestion on this would be really helpful.