Jack Corbett Thank you for reply..

identifying indexes that may be candidates for dropping or modification? user_update values modified frequently.

Identified that NC INDEX on table,

SP inside, there is one SELECT complex query written by developer also Identified NC INDEX used this SELECT statement .

In SP side UNCOMMITTED Isolation level already mentioned,

Is the Chance for dropping or modification NC INDEX Due to Isolation level?

Thanks

ananda