Re: Invisible indexes and table expansion

From: Dominic Brooks <dombrooks_at_hotmail.com>
Date: Tue, 10 Apr 2018 10:09:03 +0000
Message-ID: <DB6P190MB0501CAE90FC9475508BC7C1EA1BE0_at_DB6P190MB0501.EURP190.PROD.OUTLOOK.COM>


Probably just covered by bug 16544878.

Sent from my iPhone

> On 10 Apr 2018, at 10:50, Dominic Brooks <dombrooks_at_hotmail.com> wrote:
>
> Just working through a problem, gathering evidence and trying to reproduce. And it’s difficult for me to get an optimiser trace file in the environment.
>
> 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
i0zX+n{+i^ Received on Tue Apr 10 2018 - 12:09:03 CEST

Original text of this message