When raw SQL is used in a Select or Segment process with an input cell, IBM® strongly recommends using the
<TempTable> token to join against the incoming cell IDs. Not using the
<TempTable> token might result in longer execution times. In addition, if in-DB optimization is enabled for your flowchart, not using the
<TempTable> token might result in incorrect IDs in the output cell (that is, the output cell might contain IDs that are not in the input cell).