Hands-on task
This task is step 7 of the course “PostgreSQL: from your first database to transactions”
PostgreSQL: create an index
In the shop database, in the orders table, create an index named idx_orders_customer on the customer_id column.
Reference:psql
What you'll practise:
- indexes
- create index
- b-tree
- postgresql
- foreign key