I have a table in which i have a date column. I need to do a partition due to many (billions) rows in it. I need to do year (including future years) wise first and then months wise in each year. Could any please guide me how to do this with commands and materials..
(least date is 01-01-1998 in the table).
thanks
/MR