38
New XML Statistics
Gathered by runstats when run on XML column and XML index
Cannot be modified via update
For each of the most frequent paths in an XML column we collect
- The total number of times the path is seen
- Top-k Pathid node counts
- In how many documents it is seen
- Top-k Pathid doc counts
Same is collected for most frequent paths that lead to values
including the value itself
- Top-k Pathid-Value node counts
- Top-k Pathid-Value doc counts
Catch all stats for paths that are not frequent
New registry variables for fine tuning, db2cat for inspection