Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 balasubramaniam dAKSHINAMOORTHI (BALASUBRAMANIAMD2991)
NTT Data
Lead Pega Architect
NTT Data
US
BALASUBRAMANIAMD2991 Member since 2017 47 posts
NTT Data
Posted: Feb 10, 2018
Last activity: Feb 12, 2018
Posted: 10 Feb 2018 12:48 EST
Last activity: 12 Feb 2018 9:42 EST
Closed

Data-Admin-Operator-ID pzIndexOwnerKey Property

Hi

I need to join my class and Data-Admin-Operator-ID pzIndexOwnerKey Property as class join property for Report Definition, Class Join is getting saved fine, but when I run a report is saying

Error:
** ** One of the join conditions involving the following unoptimized property is not allowed, since it can severely degrade performance: OperPage.pzIndexOwnerKey. Revise the join conditions or optimize the property.

So my question pzIndexOwnerKey is coming from @baseclass, looks like already exposed column, then why am getting above error? if not exposed can i expose for report definition ?, is there any harm exposing this property? or any alternate option available.

***Edited by Moderator Marissa to update SR Details***

To see attachments, please log in.
Low-Code App Development
Support Case Exists

Posted: 6 years ago
Posted: 11 Feb 2018 1:14 EST
Adithya Kurmachalam (Adithya1)
Pegasystems Inc.
Solutions Engineer
Pegasystems Inc.
IN

Hi,

We can see this property(pzIndexOwnerKey) is not exposed in the pr_operators table which is the DB table mapped to Data-Admin-Operator-ID class.

I believe exposing properties should not cause any noticeable performance problems.

See below article to find the impact on performance when exposing properties.

https://docs-previous.pega.com/performance/exposing-too-many-properties-database-columns-can-affect-performance

Is it possible to use pzInskey instead of pzIndexOwnerKey in your use case? (as pzInsKey is already optimized)

 

Thank you,

Adithya

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice