PSP optimization

SQLServerCentral Article

Exploring Parameter Sensitive Plan Optimization in SQL Server 2022

  • Article

PSPO (Parameter Sensitive Plan Optimization) is a SQL Server feature that improves query performance by accepting varied data sizes based on the runtime parameter value(s) specified by the customer. It deals with the situation in which a single cached plan for a parameterized query isn't the best option for all potential incoming parameter values. Non-uniform data distributions exhibit this phenomenon. When using PSPO, SQL Server keeps several execution plans for a single query, each one customized for a particular parameter value. With the help of this feature, numerous execution plans for a parameterized query are generated, each of which is tailored for a certain range of parameter values.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2023-07-21

4,284 reads

Blogs

Inspecting TSQL Abstract Syntax Trees

By

TSQL ScriptDOM is a useful library for parsing scripts into an abstract syntax tree....

Becoming a creator, my website experience

By

Over the past few months, I have debated starting a new blog to discuss...

T-SQL Tuesday #192 Invitation: SQL Server 2025 Excitement

By

It’s that time of the month again, and once again, I’m late and I’m...

Read the latest Blogs

Forums

Do You Really Need HA?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Do You Really Need HA?

The New Database CheckDB

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The New Database CheckDB

MySQL’s BLACKHOLE Storage Engine: The Odd Feature I Wish SQL Server Shipped With

By Chandan Shukla

Comments posted to this topic are about the item MySQL’s BLACKHOLE Storage Engine: The...

Visit the forum

Question of the Day

The New Database CheckDB

I run this code: 

create database experiment
go
use Experiment
go
select DATABASEPROPERTYEX('Experiment', 'LastGoodCheckDbTime')
What is returned?

See possible answers