Join egghead, unlock knowledge.

Want more egghead?

This lesson is for members. Join us? Get access to all 3,000+ tutorials + a community with expert developers around the world.

Unlock This Lesson
1×
Become a member
to unlock all features

Level Up!

Access all courses & lessons on egghead today and lock-in your price for life.

Autoplay

    Organize Table Data with Indexes

    postgresPostgreSQL

    Relational databases can organize their data in a way that makes it more efficient to add/update/read/delete from. Similar to books, using SQL we can create indexes which defines how to our organize data behind the scenes.

    More Info

    https://www.postgresql.org/docs/9.1/indexes.html

    https://dev.mysql.com/doc/refman/8.0/en/mysql-indexes.html

    https://docs.oracle.com/cd/E11882_01/server.112/e40540/indexiot.htm#CNCPT721

    https://docs.microsoft.com/en-us/sql/relational-databases/indexes/clustered-and-nonclustered-indexes-described?view=sql-server-2017