SQL Index |¦| Indexes in SQL |¦| Database Index

SQL Index |¦| Indexes in SQL |¦| Database Index

Socratica

5 лет назад

606,193 Просмотров

Ссылки и html тэги не поддерживаются


Комментарии:

Socratica
Socratica - 18.10.2019 00:19

It's official! The Socratica Python Kickstarter was a success! Thank you to all of our supporters. Because of you, many more Python videos coming soon!! 💜🦉

Ответить
Hayden Brant
Hayden Brant - 20.10.2023 14:05

fantastic video. thank you for sharing.

Ответить
TheGrizzlyKnight
TheGrizzlyKnight - 08.10.2023 04:14

WOW My jaw is on the floor at how amazing this video is! Quality, tone and speed of voice is on point. Explanations are well thought out and provide all necessary context to comprehend. Video/Audio editing is perfect with just enough to keep it interesting and remove distractions.

Ответить
Sky
Sky - 27.09.2023 17:33

Excellent video.

Ответить
John Smith
John Smith - 26.09.2023 11:48

Thank you. Your explanation was well executed.

Ответить
Syaerul Rochman
Syaerul Rochman - 25.09.2023 17:27

subscribed, thanks, easy explanation

Ответить
truong do
truong do - 21.09.2023 05:02

thanks for great explanation!

Ответить
Annalise H
Annalise H - 19.09.2023 17:48

I'M SOO THANKFUL FOR YOU FOR MAKING THIS SO FUN!! I OWE MY UNI GRADE TO YOU 😭😭😭😭😭

Ответить
Dayglor Campos
Dayglor Campos - 17.09.2023 01:43

the best explain of index ever...

thank you for this nice work!

Ответить
Tupakula Chaithanya
Tupakula Chaithanya - 11.09.2023 18:39

perfect

Ответить
Ankit Shrestha
Ankit Shrestha - 10.09.2023 07:56

🎯 Key Takeaways for quick navigation:

Indexes in SQL are essential for speeding up queries by allowing the database to quickly locate data based on specified columns.
Without indexes, queries can be slow when dealing with large datasets, as the database must scan all rows to find matches.
Indexes are created using the "CREATE INDEX" command, specifying the table and columns to be indexed.
Indexes significantly improve query performance for the columns they are built on.
Queries that don't involve the indexed columns won't benefit from the index and may still be slow.
The database optimizer selects the most efficient query plan, considering available indexes.
Multi-column indexes can be created, and the order of columns in the index matters for query optimization.
Indexes come at a cost in terms of storage and maintenance, so they should be used judiciously.
Regularly updating and maintaining indexes is important to ensure their effectiveness in improving query performance.

Made with HARPA AI

Ответить
Frederick Sandalo
Frederick Sandalo - 09.09.2023 17:43

amazing.... she can teach me SQL all the time any time every single time.

Ответить
Murtaza Ul Hasan
Murtaza Ul Hasan - 04.09.2023 01:45

I must say, Excellent content! Brilliantly explained. Wel done!

Ответить
Supersoniq Amanyi
Supersoniq Amanyi - 27.08.2023 20:23

👏🏽👏👏

Ответить
WaitWHAT?!
WaitWHAT?! - 25.08.2023 13:11

Straight to the point unlike other tutorials. I only needed the concept really..

Ответить
Carvente Tetitla Jared Eduardo
Carvente Tetitla Jared Eduardo - 20.08.2023 22:39

i really love your videos !!

Ответить
Vitalii
Vitalii - 18.08.2023 13:43

Wow, that was quite an impressive explanation. Thanks!

Ответить
Pradnya Bapat
Pradnya Bapat - 14.08.2023 19:53

I really enjoyed your video.thank you!!

Ответить
Alerdo Ballabani
Alerdo Ballabani - 10.08.2023 19:57

No words, Amazing Video <3

Ответить
Jesus David Palomino Esquea
Jesus David Palomino Esquea - 03.08.2023 17:17

Thank you, good explanation

Ответить
Iosif Puha
Iosif Puha - 31.07.2023 00:18

This is one of the best computer science videos I've seen in my career (I'm final year 2 at uni) and whole life also, you rock!

Ответить
Godwin Shaibu
Godwin Shaibu - 23.07.2023 22:45

I don't think any educational material has been as entertaining as this playlist I just watched... It's mind blowing!... Totally the best investment of my time!

Ответить
Adolfo Hernandez
Adolfo Hernandez - 22.07.2023 18:02

Would be an index beneficial on a column with unique values?

Ответить
rafael fahreev
rafael fahreev - 18.07.2023 14:15

man i love dr evil

Ответить
Abhishek Paul
Abhishek Paul - 16.07.2023 10:51

Great video! One tip: Adding indexes to a table will speed up select commands but will also slow down other commands like insert/update/delete because the SQL server has to reconsider the indexes if any kind of modifying transaction occurs in the future.

Ответить
Erick Hernandez
Erick Hernandez - 12.07.2023 01:07

Nice video, great subtitles.

Ответить
SThi
SThi - 08.07.2023 19:58

how does the create index function behave for a table that is constantly being updated? are new rows automatically indexed, or do we need to run it each time?

Ответить
Max Fox
Max Fox - 06.07.2023 01:24

That U for the amazing content about SQL, for now on I know where to find the answers.

Ответить
Khalid Hamid
Khalid Hamid - 24.06.2023 08:11

its awsome

Ответить
張三
張三 - 22.06.2023 18:46

😄😄😄

Ответить
Balconys
Balconys - 21.06.2023 15:31

i cant believe how you didnt show a representation on how an index looks like, besides that a wounderful video

Ответить
LifeIsMine
LifeIsMine - 18.06.2023 11:49

love you so much mam,thats perfect lecture

Ответить
Faisal
Faisal - 02.06.2023 14:40

That laugh at the end was EPIC! I love your work :)

Ответить
Abhijath Prasanth
Abhijath Prasanth - 01.06.2023 10:48

Wow, this is like watching a thriller movie🍿.

Ответить
Nguyen Duc Duy
Nguyen Duc Duy - 31.05.2023 12:24

thanks for awsome work, very easy to understand in real examples

Ответить
VREP
VREP - 30.04.2023 00:53

Laugh :✔️
Explanation:✔️
New favorite data science channel:✔️

Ответить
Cristal
Cristal - 29.04.2023 23:11

This video made me excited to learn more SQL 🥰

Ответить
Michal Kubečka
Michal Kubečka - 29.04.2023 19:21

This is quite a goofy video but at the end I learned everything I needed unlike from watching other videos on this topic by different content creators. Thank you for such a great video.

Ответить
David Branson
David Branson - 29.04.2023 10:20

First, I really think these videos do a great job of teaching their lessons. Second, I really appreciate your commitment to the bit.

Ответить
Hadi
Hadi - 22.04.2023 10:29

Awesome channel👍👍 new sub indeed!

Ответить
Ezekiel
Ezekiel - 16.04.2023 00:44

100 Billion subscribers, that seems like quite a stretch

Ответить
Tamizhaga Engineering
Tamizhaga Engineering - 11.04.2023 13:28

amazing.....

Ответить
amanda
amanda - 10.04.2023 04:53

she nailed the evil laugh

Ответить
Timur Turbil
Timur Turbil - 07.04.2023 15:46

!!! WARNING !!! The primary key is always automatically indexed and unique. So, beware not to create redundant indexes.

Ответить
Iam Noob
Iam Noob - 06.04.2023 12:53

first video on indexes i clicked , amazing!!!!!!!!

Ответить
Igor M.
Igor M. - 02.04.2023 00:16

I dream about the lessons of neural networks (perceptrons and so on) from Socratica

Ответить
Khawaja Shams
Khawaja Shams - 24.03.2023 20:23

Super Excellent! Well Done!!! Thanks (y)

Ответить
Jeremy Gann
Jeremy Gann - 22.03.2023 21:41

LOL This is informative, and pretty entertaining! I like your vids.

Ответить