Posted: 27 Sep 2018 3:26 EDT Last activity: 1 Oct 2018 11:21 EDT
RFI: SQL Optimization
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***