Db2

 View Only
  • 1.  xml indexes

    Posted Wed December 06, 2023 04:06 AM
    Edited by Guy Przytula Wed December 06, 2023 04:10 AM

    we have tables with xml columns

    I can see some indexes on these columns and as lastused=0001-01-01 and they use a lot of space

    i wanted to see the indexes, but they are not in the db2look output

    is there a table/view/any other where we can see the syntax/structure of this index ?

    the table SYSINDEXXMLPATTERNS is empty

    I presume they select the complete xml and parse the string in the application. that would explain the zero usage



    ------------------------------
    Thanks for all answers
    Best Regards,
    Guy Przytula
    ------------------------------