With partitioning in place, SQL Server can quickly locate and access the partition dedicated to storing data from 2023, leading to faster query execution compared to scanning the entire table.