DAC Index Actions

Index actions can override the default index behavior for dropping and creating indexes by mode type (full load, incremental load, or both).

Scenario:-By default DAC ETL type INDEX are not parallel and this default behavior of Index creations through DAC is controlled by the file customsql.xml. Any change in the customsql.xml is applied globally to all the indices, so to make it for a particular index – INDEX actions can be used.

Steps to follow

Login to “DAC” and click on “Tools” > “Seed Data” > “Actions” > “Index Actions”

 

Then Create “New” Action give the name

In Value field click on tick then a pop appears in screen then create the two new records one for “Drop Index” and another for “Create Index” then give the SQL statements for each record

 

Create Index SQL Statement

 

Once the index action is created this has to be applied to the columns to which you want to override the default behavior.

Navigate to “Indices” tab in “Design” then query for the Index for which we need to assign the action

Then a pop up appears called “Add Actions”

Then select the action which was created in “Index Actions” and click “OK” . Do this for both the create and Drop Index

Then “Save”