Array index - slow performance

Working with Data
,
2

Please read Formatting code and log snippets in posts and reformat accordingly. We cannot really read your explain plan.

It would be nice to see the original query.