Organize Table Data with Indexes

Tyler Clark
InstructorTyler Clark

Share this video with your friends

Send Tweet

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