強制パラメータ化

• Oracle

ALTER SESSION SET CURSOR_SHARING=FORCE;

select sum(col1) from test.tab1 where col2 = 0;
select * from table(dbms_xplan.display_cursor());
select sum(col1) from test.tab1 where col2 = 123;
select * from table(dbms_xplan.display_cursor());

• MySQL

ない模様

• PostgreSQL

ない模様

• SQL Server

https://docs.microsoft.com/ja-jp/previous-versions/sql/sql-server-2008-r2/ms175037(v=sql.105)

ALTER DATABASE [AdventureWorks2014] SET PARAMETERIZATION FORCED WITH NO_WAIT
GO

ALTER DATABASE [AdventureWorks2014] SET PARAMETERIZATION SIMPLE WITH NO_WAIT
GO