I don't think I ever reflected about it, but I'm currently loading a table from a cursor and list utilities show:
Phase Number = 3
Description = BUILD
Total Work = 46 indexes
Completed Work = 0 indexes
Start Time = Not Started
In the current schema, there are 4 indexes + an XML column (which seems to contribute with 2 according to syscat.indexes). At first I thought it might be a bug counting indexes for the same table name in different schemas, but that does not count up either, since there are 10 schemas with a table named like that.
I'm just curious what the "Total Work" means for this phase?
Asked by Lennart - Slava Ukraini
(23862 rep)
Sep 27, 2021, 07:57 PM
Last activity: Sep 28, 2021, 12:50 PM
Last activity: Sep 28, 2021, 12:50 PM