Creating and altering sql indexes in alteryx workflow.

[stj1120]

Hi all,

How can I create and alter Indexes in Alteryx for the below SQL code which should automatically reflect in SQL Server database? 

ALTER INDEX ALL ON [AdventureWorks].[dbo].[Persons] 

  REBUILD; 

thanks in advance.

Best regards,

Sreenivasa Teja.

[Vijuzy]

I am not sure if there any other method, as there is no in-DB sort tool i once used Sample In-DB tool with 100% sample output with Sample records based on order selected and selected the fields need to be indexed and overwrite the existing table or creating new table using Write data In-DB tool.

[stj1120]

@MarqueeCrew @MattD @NicoleJohnson 

Kindly please help me out with the above query to replicate the same into Alteryx workflow. 

BR.

Sreenivasa Teja.

[nkrishnakris]

You can refer to this link to see how you can create an index after data processing is done, you can use "Pre Create SQL Statement option" to drop the index and create using "Post Create SQL Statement option"

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Create-an-Indexed-Field-in-a-Databa...