Slow query when passing dates

[askurat]

1. What versions are you using?
   Oracle Version: 19C
   arch:arm64
   oracledbVersion:6.8.0
   platform:darwin
   version:v23.10.0

2. Is it an error or a hang or a crash?
   None of the above.

3. What error(s) or behavior you are seeing?
   When binding a date, the query runs extremely slow. A query that should take milliseconds is taking almost a minute. This seems similar to this issue reference here: Slow queries with date in binds (oracle 11g) #1357
   The difference being, we are passing the date as a string already and the query still takes time. When hard-coding the date in the query, it queries in under a second. This happens both Mac and Linux.

[sharadraju]

Thanks for using node-oracledb!

Are you using node-oracledb Thin mode (Default) or Thick mode?

Is this an issue that you are seeing from a node-oracledb upgrade?

Can you provide a code sample, where you see this issue?

[cjbj]

@askurat check the optimizer plan as mentioned in the linked issue. Try not binding strings, but binding as dates. Review tuning tips like this.