MySQL Tutorial 9 – Indexes




HELP ME! http://www.patreon.com/calebcurry Subscribe to my newsletter: http://eepurl.com/-8qtH Donate!: http://bit.ly/DonateCTVM2.

Original source


20 responses to “MySQL Tutorial 9 – Indexes”

  1. Hi +CalebTheVideoMaker2 thank you for making this video. However, all the explanations you've provided regarding index is very similar to each other. Can you explain how they are different? Better yet, can you use concrete examples to show the differences?

    Here are some of my questions after watching the video:

    1) What is the difference between Primary and Unique if both are expected to be unique and indexed by the database engine?

    2) Why does it take longer to do insertion after indexing your data?

    3) How does fulltext work? Yes, it's like a google search, but we don't really know how google search exactly works either. How much faster or slower is it compared to the other types of indexing that you've listed?

    4) Does Fulltext need to be unique? Can I have multiple entries under fulltext with the same name?

    5) What happens if I want to cross reference 2 tables with say a user's numeric ID? How can I implement that in terms of indexing/uniqueness?

  2. eeeeehhhhwwww.. I feel uncomfortable when you write or erase something on the blackboard..:):) and it is hard to pay attention to…. Im not sure what that term in English…. that screetching sound…

Leave a Reply