Sample Header Ad - 728x90

Meaning of "Total work" for build indexes during load

1 vote
1 answer
87 views
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