Can we check how much in % of index creation is completed..?
Say I have a table of 2TB in size; I just fired a command to create an USI and after some time if i wanted to know how much of it is created; can I check it...?
afaik there's no direct way.
If you query the current size of the table using dbc.TableSizeV before running the create index and calculate the expected size of that index you can see the increase when you query dbc.TableSizeV again during the create.
If you got access to Ferret you could also run SHOWBLOCKS on that index to see the growth.