Hi,
Report has to fetch data based on country, order and ship date, order date and shipdate are in different tables. so will create reference partitioning on country and order date, country and ship date, will create local indexes on these tables. Is this approach correct and can I create the above using alter table command, when the data is already existing ?
thanks