In concurrent mode if i use id at where clause then query plan for that id column changes
How to mitigate it rather than use seperate index for id to continue without change in query plan (index scan) during concurrent activity
Why the focus on "concurrent mode"? Perhaps explain what you mean by that.
Speaking of explain, it might help if you show us the explain plans and how they are not coming out how you want. Also the table definitions, but feel free to not show columns unrelated to the problem.