SQL Index |¦| Indexes in SQL |¦| Database Index
Indexes in SQL are used to speed up SQL queries. A database index works much like an index in a book. For example, if you have a database table with a list of people, a common query would be to lookup someone by name. Creating an index means the database will not have to scan the entire table looking for matches. Instead, it will restrict its search to a small portion of the rows.
In this video we use a table with 100 million rows to illustrate how much an index can change the speed of a query.
Our SQL playlist starts here:
↪http://bit.ly/Socratica_SQL
Be sure to SUBSCRIBE for more SQL!
↪ http://bit.ly/SocraticaSubscribe
You may also enjoy our Python playlist:
↪http://bit.ly/PythonSocratica
♦♦♦♦♦♦♦♦♦♦
Ways to support our channel:
► Join our Patreon : https://www.patreon.com/socratica
► Make a one-time PayPal donation: https://www.paypal.me/socratica
► We also accept Bitcoin @ 1EttYyGwJmpy9bLY2UcmEqMJuBfaZ1HdG9
Thank you!
♦♦♦♦♦♦♦♦♦♦
Connect with us!
Facebook: https://www.facebook.com/SocraticaStudios/
Instagram: https://www.instagram.com/SocraticaStudios/
Twitter: https://twitter.com/Socratica
♦♦♦♦♦♦♦♦♦♦
SQL instructor: Ulka Simone Mohanty (@ulkam on Twitter)
Written & Produced by Kimberly Hatch Harrison (@khhsocratica) & Michael Harrison (@mlh496)
♦♦♦♦♦♦♦♦♦♦
Видео SQL Index |¦| Indexes in SQL |¦| Database Index канала Socratica
In this video we use a table with 100 million rows to illustrate how much an index can change the speed of a query.
Our SQL playlist starts here:
↪http://bit.ly/Socratica_SQL
Be sure to SUBSCRIBE for more SQL!
↪ http://bit.ly/SocraticaSubscribe
You may also enjoy our Python playlist:
↪http://bit.ly/PythonSocratica
♦♦♦♦♦♦♦♦♦♦
Ways to support our channel:
► Join our Patreon : https://www.patreon.com/socratica
► Make a one-time PayPal donation: https://www.paypal.me/socratica
► We also accept Bitcoin @ 1EttYyGwJmpy9bLY2UcmEqMJuBfaZ1HdG9
Thank you!
♦♦♦♦♦♦♦♦♦♦
Connect with us!
Facebook: https://www.facebook.com/SocraticaStudios/
Instagram: https://www.instagram.com/SocraticaStudios/
Twitter: https://twitter.com/Socratica
♦♦♦♦♦♦♦♦♦♦
SQL instructor: Ulka Simone Mohanty (@ulkam on Twitter)
Written & Produced by Kimberly Hatch Harrison (@khhsocratica) & Michael Harrison (@mlh496)
♦♦♦♦♦♦♦♦♦♦
Видео SQL Index |¦| Indexes in SQL |¦| Database Index канала Socratica
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
MySQL Tutorial for Beginners [Full Course]Things every developer absolutely, positively needs to know about database indexing - Kai SassnowskiSQL VIEWS + Complex Queries, Cross Joins, Unions, and more! |¦| SQL TutorialDifferences between Clustered vs Nonclustered Indexes in SQL ServerClustered and nonclustered indexes in sql server Part 36Relational Databases - How to Choose |¦| SQL Tutorial |¦| SQL for BeginnersDatabase Indexing Explained (with PostgreSQL)Lec-87: Why Indexing is used | Indexing Beginning | DBMSDatabase Design 39 - Indexes (Clustered, Nonclustered, Composite Index)SQL Joins Explained |¦| Joins in SQL |¦| SQL TutorialHow do SQL Indexes WorkAdvanced SQL course | SQL tutorial advancedSQL UPDATE Statement |¦| SQL Tutorial |¦| SQL for Beginnerscoursaline.com: Qu'est ce qu'un index de base de données #01Python Classes and Objects || Python Tutorial || Learn Python ProgrammingClustered vs. Nonclustered Index Structures in SQL Server10.2 B Trees and B+ Trees. How they are useful in DatabasesWhat is a DynamoDB GSI (Global Secondary Index) ?SQL Joins Examples |¦| Joins in SQL |¦| SQL Tutorial