Обсуждение: Indexing an XMLTABLE query?

Поиск
Список
Период
Сортировка

Indexing an XMLTABLE query?

От
Kanninen Anssi EXT
Дата:

Hi there!

 

Is there any way to use indexes with XMLTABLE-query to query XML type data?

I've only managed to use text[] indexes with plain xpath queries. Is there any similar workaround for XMLTABLE type queries?

 

Cheers!

  • Anssi Kanninen, Helsinki, Finland

Re: Indexing an XMLTABLE query?

От
Pavel Stehule
Дата:
Hi

pá 9. 10. 2020 v 7:40 odesílatel Kanninen Anssi EXT <Anssi.Kanninen@digia.com> napsal:

Hi there!

 

Is there any way to use indexes with XMLTABLE-query to query XML type data?

I've only managed to use text[] indexes with plain xpath queries. Is there any similar workaround for XMLTABLE type queries?


XMLTABLE returning set of records, and for these functions there are not functional indexes

Regards

Pavel


 

Cheers!

  • Anssi Kanninen, Helsinki, Finland