Question

8
Replies
944
Views
JuliaO52 Member since 2016 6 posts
Tecmgroup
Posted: July 28, 2017
Last activity: July 28, 2017
Closed

pr_read_from_stream is used for the optimised property

Hi all

in one of our environments (in fact, in a PROD), reports in Pega 7.1.8 run sql with pr_read_from_stream on a simple property from PC_*_WORK table that is optimized (moreover, index on this property is created in the table). Table PC_*_WORK contains 350000+ of records, property is used in a when condition, so this is realy an issue.

Property was optimized via Pega in all environments. Actually, in all of them it is absent in the External mapping of the class rule, but in DEV and UAT sql uses corresponded field, while in PROD it uses blob for this property.

Any idea?

Thanks in advance

Reporting Data Integration
Moderation Team has archived post
Share this page LinkedIn