# Prisma 5.4.0 — Release & Upgrade Intelligence
- **Product:** Prisma (https://prisma.io)
- **Version:** 5.4.0
- **Released:** Oct 04, 2023
- **Impact Score:** 5/10
- **Breaking Changes:** Not verified
- **Canonical Analysis:** https://changelogs.us/prisma/updates/5.4.0/

## Executive Summary (TL;DR)
Prisma 5.4.0. Source highlight: 🌟 **Help us spread the word about Prisma by starring the repo or tweeting about the release.** 🌟

## Improvements
- Removed an unnecessary `INNER JOIN` used in relation filter queries (Big thank you to @KhooHaoYit for helping out)
- Use of `LEFT JOIN`'s for to-one relations. Previously, Prisma made use of sub-queries to fetch data.
- Removing all `SELECT` queries used to fetch data that would be used as input for the `DELETE` operation. In some cases, this also improves index usage.
- Removing the transaction previously used as it’s now a single atomic operation.

## Bug Fixes
- Quick Fix: when `@@schema` is defined in a block without the `schemas` attribute

## Upgrade Command
```bash
npm install --save-dev --save-exact prisma@5.4.0
```