Hello,
Am trying to convert the access path for one of the tables in my query to matching index scan but unable to do it.All of the indexable and stage one predicates are being utilised in my program, and optimiser is choosing the indexed access paths for all of them, with match cols 1 or greater that 1.Its just this for this one table that am getting
a non matching index scan.Is there any way to convert the nonmatching index scan to a matching index scan.Also, no sorting is being done.