0

Is it possible to create an index on a column of an Oracle table registered in metadata of SAS Data Integration Studio? If it is, which type of index is created? Simple one or which one?

Brian Tompsett - 汤莱恩
  • 5,753
  • 72
  • 57
  • 129
zuluk
  • 1,557
  • 8
  • 29
  • 49

1 Answers1

2

yes we can create an index on output table of oracle database.After registering the output table you can find the index tab/keys tab .there we can create index(either it may be simple(for simple the index name and column name should be same) and for composite index you can able to choose multiple columns

sandeep
  • 21
  • 2
  • Thanks, you are right. My question had another context. I meant to "create" an index in DIS (metadata) for an existing input table that already has an index. I think this is not possible, but SAS takes automatically the index defined in Oracle. – zuluk Mar 28 '14 at 08:13