when to use force_matching with sql profiles?
hi
when to use force_matching with sql profiles?
Our queries only use bind variables. We don't use literals/values when writing the query. I assume in this case force_matching is not needed?
I took a look at this document
"How To Use SQL Profiles for Queries Using Different Literals Using the Force_Match Parameter of DBMS_SQLTUNE.ACCEPT_SQL_PROFILE (Doc ID 1253696.1)"
It's a good document but it was really clear to me. I also checked a few blogs but I couldn't really get definitive answer.
Thank you