Skip to Content
0
Former Member
Jul 28, 2016 at 07:24 PM

Suggestion needed for IQ upgrade 16 from 15.4

48 Views

Planning to upgrade IQ 15.4 to IQ 16 .. Database size : 15 TB

Wanted to check . Is it mandatory rebuild index for wide columns .. ( Not sure how long rebuild will take ) ..

For rebuilding index for all wide columns in database . Can I run below command instead of running for individual table/column .

sp_iqrebuildindexwide [ table_name ] [, table_owner] [, level]

sp_iqrebuildindexwide NULL,NULL,1

So if I pass table_name and table_ower as NULL . Will it rebuild index for whole database for wide column .

Appreciate your suggestion .

Thanks

Ajay Pandey