We are using tpt stream operator to update or insert in four different tables based on the case condiiton.
bu the performance is not good. So we are planning to use session partitioning in the script .can we apply session partitoiing in tpt script ??
if yes then how .
let me know the performance improvement techniques for tpt stream operator.
Not certain what you mean by "session partitioning". You can use SERIALIZE ON (a subset of) Primary Index columns in the APPLY statement, so that rows with the same PI will be directed to the same session.
Tuning STREAM usually starts with making sure you don't have an issue with blocking (SERIALIZE can help there) and adjusting Pack and number of sessions.