I am trying to create a metamorph inverted index on one of my tables. The table size is huge with 2.7 million records. The index creation is taking a long time.
create metamorph inverted index xdocum on Help (Tide\desc\kewo\Bod,Visi,Comm,int_flg,Prd,Rstlag,Dod,Docpe,Quay);
Can you please let us know how we can make the index creation faster. I have to recreate the index.
The time to create the index usually depends on the size of the data in MB. The factors that will impact it are the speed of the drives with the data and index, using separate drives for data, index, and temporary files may help. Also make sure indexmem is not set to a point where the index creation process is swapping as that will slow it down as well.
Thanks for the response, the blb table size is 70G where as the normal table size is 657M.
These are the settings which we have set before creating the index.
<sql novars "set delexp=0;"></sql>
<sql novars "set addexp='\alnum{1,30}';"></sql>
<sql novars "set addexp='\digit=[\digit\.,+]{1,30}';"></sql>
<sql novars "set addexp='>>[\xc0-\xfd]=[\x80-\xbf]+';"></sql>
<sql novars "set addexp='>>\alnum=[\alnum\x5c\x5f\x2d\x26\x23\x40\x2e\x25\x2c]{1,30}';"></sql>
<sql novars "set indexmeter=2;"></sql>
do we have to set anyother variable to fasten the process.