Update takes forever and dont uses index despite new stats

11.2.0.2

Hi,

We have this update which does a full table scan, dispite the indexes.

UPDATE MFT_SALE

SET PTOT_ATTR_KEY = :1,

CONT_ATTR_KEY = :2,SEAS_KEY = :3,COLR_GRP_ATTR_KEY = :4,ASRT_GRP_ATTR_KEY = :5,ASRT_ATTR_KEY = :6,STOR_LVL_KEY = :7,SUPP_ATTR_KEY = :8,PRCE_KEY = :9,AUDT_KEY = :10,IN_PRCE = :11,RGLR_SALE_QTY = :12,PROM_SALE_QTY = :13,CLR_SALE_QTY = :14,RGLR_SALE_AMT = :15,PROM_SALE_AMT = :16,CLR_SALE_AMT = :17,VAT_RGLR_SALE_AMT = :18,VAT_CLR_SALE_AMT = :19,VAT_PROM_SALE_AMT = :20,LOAD_TSTM = :21WHERE DAY_TIME_KEY = :22 AND SKU_PROD_KEY = :23 AND STOR_LOC_KEY = :24

| Id  | Operation               | Name     | Rows  | Bytes | Cost (%CPU)| Time     | Pstart| Pstop |