Gather stasts for FBIs
Hi all
I'm working with oracle 11.2.0.4 and it looks that the CBO is not considering execution plan on my FBIs, so reading this note (Oracle SQL tips)
I'd like to know how may i do the gather stats for that table considering these indexes
CREATE INDEX FMA_STP_DEP_DTE_IDX ON FMA_STOP (TRUNC(NVL("EXP_DEP_DTE","PLN_DEP_DTE")) ASC);
CREATE INDEX FMA_STP_ARR_DTE_IDX ON FMA_STOP (TRUNC(NVL("EXP_ARR_DTE","PLN_ARR_DTE")) ASC);
CREATE INDEX FMA_STP_ACT_ARR_DTE_IDX ON FMA_STOP (TRUNC("ACT_ARR_DTE") ASC);
CREATE INDEX