Welcome to the IBM Connections Product Ideas Lab! The place where you can submit product ideas and enhancement request. We encourage you to participate by voting on, commenting on, and creating new ideas. All new ideas will be evaluated by the IBM Product Management & Engineering teams, and the next steps will be communicated. While not all submitted ideas will be executed upon, community feedback will play a key role in influencing which ideas are and when they will be implemented.

For more information and upcoming events, please visit our IBM Connections page.

Improvements on backend SQL queries

Requesting improvements on backend SQL queries.

Observations indicate that:

  • A number of the SQL queries are doing hard parsing
  • Most of them have common text
  • Due to the use of literals (instead of bind variables), we see multiple SQL IDs and different parent cursor IDs for each SQL.¬†

Cursor sharing can be improved by changing the SQL queries to use bind variables 

  • Avatar32.5fb70cce7410889e661286fd7f1897de Guest
  • May 6 2019
  • Under review
  • Attach files