I'm using a workbench with a workspace runner. The workspace translates files into MS SQL tables. I would like to index some of the columns once all the files have been processed.
Can you please help?
Thanks, Moni
Question
SQL - Index columns
Hello,
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
You can use the SQLExecutor to create the indexes, e.g.:
CREATE INDEX index_name ON table_name (column_name)If you want to make sure the SQLExecutor is executed last, use e.g. a FeatureHolder and then a Sampler (1st feature) before the SQLExecutor.
You could also put the SQLExecutor into a child workspace and have it called with another WorkspaceRunner from the master workspace.
+9- Contributor
@honkovam I second what david_r suggested to create the index like eg
CREATE INDEX index_name ON table_name (column_name)
but I usually put it into the navigator panel in the SQL Statement to execute after translation parameter if you wanted to cut down on having workspace runners
+18- Supporter
Or just use the FeatureWriter, that is if you are using FME 2016, and after it the SQLExecutor