Is x a parameter because it doesn't look like it? MSSQL has parameter sniffing a... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		SigmundA on March 18, 2024 \| parent \| context \| favorite \| on: I wrote a new JIT compiler for PostgreSQL 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 on March 18, 2024 [–]

I 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.

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact