SQL Advanced Videos #1: B-Tree and Clustered Index

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

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

  • @jamescissel2485
    @jamescissel2485 Год назад +1

    Dude thank you so much for sharing these videos you are a huge help!

  • @joseantoniolopezmesa6807
    @joseantoniolopezmesa6807 7 лет назад +1

    This is the kind of channel I have been always searching for. It takes some basic CS knowledge, but that's the reason why you do the disclaimer that is related to advanced topics. Thanks !!

  • @johnson554671
    @johnson554671 5 лет назад

    Wow this summed it up very good! Thx

  • @lasithadulshan7357
    @lasithadulshan7357 4 года назад

    Where we use leaves and this nodes ?

  • @sandeeplakde9685
    @sandeeplakde9685 8 лет назад +2

    What is The Difference Between Cluster index And Btree ?
    And Where We Use Cluster And Btree Index?

    • @SQLTVChannel
      @SQLTVChannel  8 лет назад +4

      a clustered index is a b-tree. whenever you specify primary key constraint it is automatically implemented as clustered index and thus as a b tree. BTW each index no matter if clustered or non clustered is implented as b tree. in a clustered index you have the rows in the b tree leafs and in a non clustered you have only the key in the leafs

    • @sandeeplakde9685
      @sandeeplakde9685 8 лет назад +1

      +Tux Tutorial Videos Thank You So Much

  • @LoveScreamTrue
    @LoveScreamTrue 3 года назад

    Thank you!

  • @Daidera91
    @Daidera91 5 лет назад

    good stuff

  • @lasithadulshan7357
    @lasithadulshan7357 4 года назад

    Thank u

  • @MarcoNiedermeyer
    @MarcoNiedermeyer 5 лет назад

    Danke

  • @TranDinhNgochoaian
    @TranDinhNgochoaian 7 лет назад

    Exam b tree for SQL?

    • @SQLTVChannel
      @SQLTVChannel  7 лет назад

      I don't really know what your questions is about?

  • @navneetkushwaha1830
    @navneetkushwaha1830 3 года назад

    I m from India.

  • @petter9078
    @petter9078 7 лет назад

    7:37 ... hahahah, n times logarithm for men .. n*log(for men)