Db2

Db2

Where DBAs and data experts come together to stop operating and start innovating. Connect, share, and shape the AI era with us.


#Data


#Data
#Databases
#Operatingsystems
#Db2
#Databasesolutions
 View Only

  • 1.  xml indexes

    Posted 12/06/23 04:06 AM
    Edited by Guy Przytula 12/06/23 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
    ------------------------------



Related Content