Package: Adding Indices Task

Other tasks inserted new rows and updated existing rows on the BBDW database. The Adding Indices task indexes the warehouse table. CREATE_OR_DROP_FACT_INTERACTIONRESPONSE_INDICES is a procedure to create or drop indexes. Specifying 1 indicates to create indexes.

exec BBDW.[CREATE_OR_DROP_FACT_INTERACTIONRESPONSE_INDICES] 1;

The section about the revisions process discusses how to add a revision to create a stored procedure such as the index create procedure in the example. For more information, see Revisions Spec: Drop and Create Indexes