Invisible indexes and table expansion

In an 11.2.0.4 environment, I’ve got a whole bunch of queries now using table expansion - VW_TE_2.

Recent change was to add three local indexes, each with a subset of partitions as usable - something which table expansion was designed to help with.

But they are invisible indexes.

So my theory is the invisibility is limited - ie they are visible enough to cause table expansion - but then can’t be used.

Anyone looked into something similar?

Cheers
Dominic

Sent from my iPhone†Ûiÿü0ÁúÞzX¬¶Ê+ƒün– {ú+iÉ^ Received on Tue Apr 10 2018 - 11:50:17 CEST