For our application we use tables through SQL Management Server Studio and we have a connection through integration studio. In order to speed up some of the queries, we would like to index few columns. We have already done this in SQL. I just wanted to know if this automatically indexes the tables in OS as well or I would have to define this somewhere? The reason I want to make sure is because when I double click the table name to see its properties, I am unable to see those indexes in the index tab. Hence why I feel I am missing a step to define the index in the integration studio somewhere but am unsure where I do that. Would really appreciate your inputs on this!

Thank you,

Hi Archit,

Indexes are used by the database engine when a query is executed. I don't think it's even possible to not use them if they're there :).