mgalleno Member since 2017 9 posts
Accenture Inc
Posted: September 27, 2018
Last activity: October 1, 2018

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 SR Exists
Moderation Team has archived post
Share this page LinkedIn