3 ms·
Is x a parameter because it doesn't look like it? MSSQL has parameter sniffing and will make multiple plans based on incoming parameters I would be surprised if
by SigmundA 3y ago
Is x a parameter because it doesn't look like it? MSSQL has parameter sniffing and will make multiple plans based on incoming parameters I would be surprised if Oracle does not do the same. It can actually be problematic to sniff parameters sometimes and it can be disabled with a hint!
- aeyes 3y agoI just made up something simple but yes, I had these problems with bind variables in prepared statements. > SELECT * FROM t WHERE x = :var; But I haven't used Oracle in years and back in the day, there was no bind variable peeking.