In a previous article we saw why a query can run with a different plan and how to force one in SQL Server. In this article we will see how to force a plan in an Oracle database with... read more
How to force a plan in SQL Server and why not
Sometimes, depending on the value we have given to a parameter, a query may run with a different plan (execution plan) and have a different duration. This phenomenon is called parameter sniffing. This may be due to… read more
