INFORMATICA USES SECONDARY INDEXES?

Database

INFORMATICA USES SECONDARY INDEXES?

A developer indicated to me that Informatica will not use secondary indexes. Is this true?
5 REPLIES

Re: INFORMATICA USES SECONDARY INDEXES?

If you are doing Fload or Mload with informatica then it would not work with secondary indexes. However, in Mload it would work with Non-unique SI, but not with SI.

Re: INFORMATICA USES SECONDARY INDEXES?

I meant, "not with unique* SI"

Re: INFORMATICA USES SECONDARY INDEXES?

How about an UPDATE TPT process workflow? Will it utilize SI if they are created over the columns in the where clause?

Re: INFORMATICA USES SECONDARY INDEXES?

No, I don't think UPDATE TPT also supports unique SI.

Re: INFORMATICA USES SECONDARY INDEXES?

Thank you for the answer and from what I see, that is correct!