All tasks

Partial Index

Intermediate

Create a partial index only for active products (WHERE is_active = true). This saves space and speeds up queries on a subset of data.

Category
Greenplum DDL
Estimated time
~15 min
Databases
Greenplum
Tags
DDLCREATE INDEXчастичный индексWHERE

Sign in to solve

Start Solving