Indexes and Constraints

Indexes and Constraints

Explore Indexes and Constraints in YSQL and YCQL
Primary keys
Explore the use of Primary keys in YSQL and YCQL with examples.
Foreign keys
Explore the use of Foreign keys associated with Primary keys in YSQL.
Secondary indexes
Explore Indexes to optimize your database performance.
Unique indexes
Explore Unique indexes in YSQL and YCQL with examples.
Partial indexes
Explore Partial indexes in YSQL and YCQL with examples.
Expression indexes
Explore Expression indexes in YSQL with examples.
Covering indexes
Explore Covering indexes in YSQL with examples.
GIN indexes
Use GIN indexes in YSQL to run efficient queries.
Other constraints
Explore CHECK and NOT NULL constraints to optimize your database performance.