Question

SQL - Index columns

  • 28 July 2016
  • 3 replies
  • 17 views
H
Badge
Hello,

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

3 replies

david_r
Rank
Userlevel 4

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.

ciarab
Rank
Badge +9

@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

itay
Rank
Badge +16

Or just use the FeatureWriter, that is if you are using FME 2016, and after it the SQLExecutor

Reply


Community Stats

28,723
Posts
109,511
Replies
36,560
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.