All Forums Database
arpitsinha 13 posts Joined 06/15
05 Aug 2015
Monitor Index Creation

Hi,
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...?
 

Regards, Arpit

dnoeth 4628 posts Joined 11/04
05 Aug 2015

Hi Arpit,
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.

Dieter

arpitsinha 13 posts Joined 06/15
05 Aug 2015

Thanks Dieter

Regards, Arpit

You must sign in to leave a comment.