query is running very slow if the index hint is not forced

[tamilselvan]

10053 trace will tell you why Oracle chose a particular access path.

Can You post the trace here?

Tamil