Hi,
The PRICE table is having 100 Billion records, its partitioned by TYPE_KEY & FROM_DT.
T_PRICE ( sku_key number, type_key number, price number, from_dt date, to_dt date, is_current varchar2(1));
Most of the queries uses partitioned columns TYPE_KEY and FROM_DT but also uses TO_DT.
When we use TO_DT, optimizer is doing a full table scan! I believe Optimizer do not know the relation between FROM_DT & TO_DT
Its doing good when we use only FROM_DT, we can understand that.
When we use only FROM_DT
Appreciate your advise and comments.
Regards
Hesh