---
title: "Partial and expression indexes"
description: "How can you restrict an index using a predicate or expression?"
status: "coming-soon"
language: "en"
canonical: "https://bulnik.dev/en/articles/topics/T40.04/"
topicId: "T40.04"
---

> Coming soon — this article is being prepared. Below are its question, intended outcome, and place in the story.

## The question

How can you restrict an index using a predicate or expression?

## What we will work through

Restrict an index using a predicate or expression.

## Before you begin

Previously covered: B-tree indexes; EXPLAIN and EXPLAIN ANALYZE.

- [B-tree indexes](/en/articles/topics/T40.02/)
- [EXPLAIN and EXPLAIN ANALYZE](/en/articles/topics/T40.01/)