0

I just found out that when googling for the parameter sniffing, SQL server is also on the recommended search list but not other RDBMS such as Oracle, MySQL, PostgreSQL. Even in this community, tag almost comes with , but not for the others.

Is parameter sniffing just a SQL Server thing? If so, why is that? If not, what is the reason that parameter sniffing is almost only linked with SQL Server?

Improve this question
4
  • Does this answer your question? Parameter sniffing is a feature of the Optimizer. Different RDBMSs will have different implementations with different terminology, but are ultimately compatible features. Does oracle database suffer from parameter sniffing issue
    – AMtwo
    Commented Sep 18, 2020 at 2:56
  • @AMtwo Partially. It doesn't answer the last part of my question: If not, what is the reason that parameter sniffing is almost only linked with SQL Server? Should I change my question to remove the duplicated part?
    – user2652379
    Commented Sep 18, 2020 at 3:02
  • 2
    "parameter sniffing" is just the SQL Server terminology. That term is unique to SQL Server. The concept is not. (In Oracle, it's called "peeking")
    – AMtwo
    Commented Sep 18, 2020 at 3:17
  • @AMtwo Ah, that might explains the last part of my question. Thank you. I wish I could accept your comment as the answer.
    – user2652379
    Commented Sep 18, 2020 at 3:53

0

Reset to default

Browse other questions tagged or ask your own question.