/
Create Tasks to Drop & Recreate Index on AstunLocationLookup

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]. 

Related content

Create Task to Build the Address Lookups
Create Task to Build the Address Lookups
More like this
Step 3 - Import AddressBase into iShare
Step 3 - Import AddressBase into iShare
More like this
Configure Location Lookups
Configure Location Lookups
Read with this
Step 9 - Create & Schedule Job to Import & Build AddressBase Premium data
Step 9 - Create & Schedule Job to Import & Build AddressBase Premium data
More like this
Create Task to make Address Lookups mappable
Create Task to make Address Lookups mappable
More like this
Create Task to add AddressBase View to Geometry columns
Create Task to add AddressBase View to Geometry columns
More like this