Rewriting SQL queries for Performance in 9 minutes

Поделиться
HTML-код
  • Опубликовано: 21 дек 2024

Комментарии • 7

  • @JP-td8gt
    @JP-td8gt 6 лет назад +1

    Bravo! Indeed, these fundamentally effective methods work like a charm.

  • @rolandomysqldba
    @rolandomysqldba 13 лет назад +1

    I actually remembered the principles from this video to answer a question on the StachExchange about querying a large set of data joining three tables and yeiding query times between 0.00 and 0.03 seconds no matter how large the dataset is.

  • @roughsealtd
    @roughsealtd  12 лет назад +2

    You're absolutely correct. My bad. I have added a bubble to correct it. Glad to see that some people watch this very carefully :-)

  • @bullabraham
    @bullabraham 14 лет назад +1

    A good approach through fundamental design!

  • @smbaxter12650
    @smbaxter12650 6 лет назад

    You are funny. I enjoyed your book plug. Thank you for this video

  • @alphamyu
    @alphamyu 12 лет назад +1

    @6:55, shouldn't it be u.userID = x.userID, and not u.userID = i.userID ?

  • @37dine
    @37dine 12 лет назад

    simple and very clear. thanks