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
------------------------------