Skip to Main Content
HCL Connections Ideas Portal

Welcome to the HCL 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 HCL 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 HCL Connections page.

Status Under Consideration
Created by Guest
Created on May 6, 2019

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 

  • Attach files
  • Admin
    Adam Gartenberg
    Reply
    |
    May 27, 2021

    Can you please share some examples of queries that fall into the situation you are describing?