=
, <
, >
, BETWEEN
, and IN
.IS NULL
or IS NOT NULL
conditions.LIKE
or ~
.employees
table and demonstrate B-tree index usage:
=
operator). Here’s how they work:
employees
table and demonstrate Hash index usage:
employees
table with a location
column representing the employees’ office locations (stored as geometric points). We want to efficiently query employees based on their proximity to a specific location.
emp_location
(key, posting list)
pairs.employees
table with a column skills
(an array of skills). Let’s create an employees
table:
skills
column:
Alice
Alice
Bob
pages_per_range
storage parameter.hire_date