SQL Performance (MOSC)

MOSC Banner

Gather stasts for FBIs

edited Feb 16, 2015 10:22AM in SQL Performance (MOSC) 7 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center