---
title: "Comment by Mustansir Zia on \"Designing SQL databases for rock solid data quality\" | Hashnode"
description: "I personally loved the topic on partial indexes and how it solves the use case of uniqueness in case there are soft deleted rows. (Since every NULL is considere"
url: "https://hashnode.com/posts/designing-sql-databases-for-rock-solid-data-quality/65a3fb65400115ca928ef28e/comment/665d60990bd7e83589d317d1"
---

[Discussion](https://hashnode.com/posts/designing-sql-databases-for-rock-solid-data-quality/65a3fb65400115ca928ef28e)

Comment [Designing SQL databases for rock solid data quality](https://hashnode.com/posts/designing-sql-databases-for-rock-solid-data-quality/65a3fb65400115ca928ef28e)

[Mustansir Zia](https://hashnode.com/@mustansir)

[Jun 3, 2024](https://hashnode.com/posts/designing-sql-databases-for-rock-solid-data-quality/65a3fb65400115ca928ef28e/comment/665d60990bd7e83589d317d1)

I personally loved the topic on partial indexes and how it solves the use case of uniqueness in case there are soft deleted rows. (Since every NULL is considered a unique value)

It is worth mentioning however, that partial indexes are not yet supported in every database engine including the one in the latest version of MySQL.