Database Administration (MOSC)

MOSC Banner

Functional-based index

edited Mar 3, 2011 4:19AM in Database Administration (MOSC) 3 commentsAnswered

Hey all,

I have a question regarding functional-based indexes in 10gR2, more specifcially 10.2.0.3.
We noticed last week some of our functional-based indexes are not updating themselves. When we use a query using a functional-based index we get no rows returned.
Now I rebuilt the index in question and re-ran the query and suddenly records are returned.

I was not aware that functional-based indexes need to be rebuilt manually, I thought this was part of the database internal engine as this is the first time I notice this.

Does anyone have any feedback on this?

Thanks 

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