parameter-sniffing Archives

Parameter Sniffing and Multiple Plans in Cache

By adminPosted on March 14, 2023

Question : We have a multi-tenanted database. FirmID is the partition key and we have lots of different firms. I […]

By adminPosted on March 7, 2023July 1, 2022

Question : I am trying to optimize performance for a server and this particular query was causing huge reads from […]

By adminPosted on March 2, 2023

Question : I just had a problem at work where a stored proc, being called by some C# code, was […]

By adminPosted on January 5, 2023

Question : We have a production app which runs ok normally, but gave us very poor performance this week. As […]

By adminPosted on March 23, 2022

Question : These two settings seem to contradict each other. One forces plan parameterization so that only one plan gets […]

By adminPosted on February 14, 2022

Question : I would like someone to explain to me how each of the two queries below would generate their […]

By adminPosted on January 24, 2022

Question : I’ve heard of and encountered parameter sniffing in stored procedures before. But today I ran into the first […]

By adminPosted on November 11, 2021

Question : I have a table containing 10 years worth of ‘package scans’. Somebody scans a package and it records […]

By adminPosted on October 21, 2021

Question : Does oracle database suffer from parameter sniffing issue in stored procedures? Considering there are millions of pages written […]

By adminPosted on October 3, 2021

Question : I am trying to optimize performance for a server and this particular query was causing huge reads from […]