SQL Performance (MOSC)

MOSC Banner

Performance issue with a index.

edited Apr 18, 2017 5:00AM in SQL Performance (MOSC) 8 commentsAnswered

when I run oracle statistics the index still have performance issues. But  I drop and re-create an index. There are no performance issues. That's good. But what is the reason behind this.

I tired to analyze it.

Analyze index PLN_ORD_35 validate structure; and then I do this

SELECT name,height,lf_rows,lf_blks,del_lf_rows FROM INDEX_STATS;

PLN_ORD_35242331880

I don't find anything strange.

My question is how can I found what is the issue is?

Thanks in advance for helping me.

Kind regards,
Santhosh Challa.

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