Create Tasks to Drop & Recreate Index on AstunLocationLookup
If you wish to make searching AddressBase quicker then you can create two extra Stored Procedure Tasks to Drop and then Create an Index on the AstunLocationLokup table.
Add the Drop Index Task
In the tree, right click on the Build My Addresses from AddressBase Job you have just created and select New Task.
Select the Stored Procedure type and click OK.
Name
Enter a name for the task e.g. Drop Index on AstunLocationLookup.
Connection Details
Select the iShare database from the list. Then select the Workflow radio button as this will limit the list of available Functions and then select the at_wkf_executecmd entry from the list (from v6.0.0 this is called wkf_executecmd under the -Workflow- Function filter).
Select the Parameter No 1. in the list and paste the following into the Edit parameter 'cmdtoexecute' box.
Now we need to run the task to make sure that it works correctly.
Right click on the Task and select Drop Index on AstunLocationLookup [or whatever you called the task].
Add the Create Index Task
In the tree, right click on the Build My Addresses from AddressBase Job you have just created and select New Task.
Select the Stored Procedure type and click OK.
Name
Enter a name for the task e.g. Create Index on AstunLocationLookup.
Connection Details
Select the iShare database from the list. Then select the Workflow radio button as this will limit the list of available Functions and then select the at_wkf_executecmd entry from the list (from v6.0.0 this is called wkf_executecmd under the -Workflow- Function filter).
Select the Parameter No 1. in the list and paste the following into the Edit parameter 'cmdtoexecute' box.
Now we need to run the task to make sure that it works correctly.
Right click on the Task and select Create Index on AstunLocationLookup [or whatever you called the task].