Question

8
Replies
1017
Views
Julia Olkhovska (JuliaO52)
Tecmgroup

Tecmgroup
UA
JuliaO52 Member since 2016 6 posts
Tecmgroup
Posted: July 28, 2017
Last activity: July 28, 2017
Posted: 28 Jul 2017 8:07 EDT
Last activity: 28 Jul 2017 11:38 EDT
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, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.