Mahalia Rose Galleno (mgalleno)
Accenture Inc

Accenture Inc
mgalleno Member since 2017 9 posts
Accenture Inc
Posted: September 27, 2018
Last activity: October 1, 2018
Posted: 27 Sep 2018 3:26 EDT
Last activity: 1 Oct 2018 11:21 EDT

RFI: SQL Optimization

Hi All,

We would like to improve the performance of the application. Some queries are causing slow performance and long-running queries:
1. Supposed we have obj-browse that retrieved data from a table with blob columns, what is the best way to increase the performance of the obj-browse? Should we create new columns for those being used in that activity? Or should we create columns for all the blob under that table? What do you suggest in handling these BLOB reads?

2. How should we handle or optimize those queries with typecasting and for those that uses functions or calculations?

Thanks in advance!

***Edited by Moderator: Pallavi to update platform capability tags***

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

Pega Customer Service System Administration Reporting Data Integration Support Case Exists
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.