From the course: PostgreSQL Essential Training
Join today to access over 23,400 courses taught by industry experts.
Add indexes to a table - PostgreSQL Tutorial
From the course: PostgreSQL Essential Training
Add indexes to a table
- [Instructor] The Browser or Object Explorer pane on the left side of pgAdmin allows you to navigate the contents of different database objects. For instance, we've seen that tables are made up of a number of different things. We have a collection for columns and inside of there are all of the columns that make up the structure of the table. We also have a folder for Constraints. For the products table, there are currently two constraints. One for the primary key, which will ensure that no two rows have the same value in the Product ID column. The other one is the foreign key constraint, which makes sure that values stored in the category ID column can be linked to a valid row in the related categories table. The next collection down in the interface is for Indexes and that's what I want to spend a few minutes talking about now. So what are table indexes? Well, in the real world, you're probably familiar…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.