SQL Index ¦ Indexes in SQL ¦ Database Index

>> YOUR LINK HERE: ___ http://youtube.com/watch?v=fsG1XaZEa78

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 : / socratica • ► Make a one-time PayPal donation: https://www.paypal.me/socratica • ► We also accept Bitcoin @ 1EttYyGwJmpy9bLY2UcmEqMJuBfaZ1HdG9 • Thank you! • ♦♦♦♦♦♦♦♦♦♦ • Connect with us! • Facebook: / socraticastudios • Instagram: / socraticastudios • Twitter: / socratica • ♦♦♦♦♦♦♦♦♦♦ • SQL instructor: Ulka Simone Mohanty (@ulkam on Twitter) • Written Produced by Kimberly Hatch Harrison (@khhsocratica) Michael Harrison (@mlh496) • ♦♦♦♦♦♦♦♦♦♦

#############################

New on site