Suppose, I had a join qry which is using join indices currently. Incase I change the joining column the it might not use join indices. Is there any way to force join indices?
I do not beleive that a query can be forced to use join index, as the use of join index is a processing decision made by the optimizer based on statistics. The only way is to collect the statistcs as required and keep them updated. This way optimizer will be better able ti use index joins in query execution.