What are Clustered Indexes vs. Non-Clustered in SQL Server 2008 R2 Software Tutorial

What are Clustered Indexes vs. Non-Clustered in SQL Server 2008 R2 Software Tutorial

Edward Kench

12 лет назад

79,424 Просмотров

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


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

@virtualuni890
@virtualuni890 - 30.07.2023 16:21

your 11 years old video is worth it for me today because it helps me to understand concept of clustered data because my final term is coming and dbms subject is also there. thanx to explain in a simple way

Ответить
@fentazimohamedreadh5274
@fentazimohamedreadh5274 - 17.01.2023 20:01

THANK YOU! THANK YOU THANK YOU THANK YOU SO MUCH
Dear god why don't people use real and simple examples to explain something…
God bless you sir.

Ответить
@apraveena
@apraveena - 21.12.2022 15:43

Very good video about clustered index.. was there information about non-clustered that I miss.. or was it supposed to be obvious?

Ответить
@gotchihaeyo1825
@gotchihaeyo1825 - 09.02.2022 01:28

OMG. THANK YOU.

Ответить
@robinshama6895
@robinshama6895 - 26.04.2021 14:51

Great video

Ответить
@b.letthia2484
@b.letthia2484 - 07.07.2020 05:53

Finally understand clustered index!

Ответить
@jakewestin4176
@jakewestin4176 - 31.10.2019 02:44

Can't believe I had this so wrong for so long and that NONE of the other videos or hundreds of pages of learning material even mentioned the fact the index IS THE TABLE ITSELF

Ответить
@thomastum6992
@thomastum6992 - 17.01.2019 02:01

Wait, is this some advanced text to speech voice talking?

Ответить
@hugokornelis6840
@hugokornelis6840 - 29.07.2018 16:49

Excellent, now i can add this to my training schedule!

Ответить
@mgrabo84
@mgrabo84 - 06.02.2017 06:19

no explanation of non-clustered or any of its differences to clustered so its a misleading title

Ответить
@Akumaryu700
@Akumaryu700 - 09.09.2014 00:33

Besides feeling like if I'm getting screamed at by an older sibling or parental figure, I still learned exactly what was described on this video. Very informative. Thank you!

Ответить
@Akumaryu700
@Akumaryu700 - 09.09.2014 00:17

Besides feeling like if I'm getting screamed at by an older sibling or parental figure, I still learned exactly what was described on this video. Very informative. Thank you!

Ответить
@papasmurf73
@papasmurf73 - 05.09.2014 04:04

Well done!  Super clear.  Thank you!

Ответить
@Keithjo74
@Keithjo74 - 17.05.2014 05:30

clear and easy to follow, well done.

Ответить
@crummmycheese
@crummmycheese - 28.12.2013 11:51

Nice explanation

Ответить
@ibknl2000
@ibknl2000 - 27.11.2013 16:46

Nice video, but introduction of Non Clustered Index is missing

Ответить
@krismaly
@krismaly - 28.06.2013 08:22

Good video and I liked it. Do you have a blog where I can see all your presentations? If you never mind if I ask you what recording software you used in creating this video?Thanks a bunch.

Ответить
@samoory100
@samoory100 - 10.06.2013 12:47

if i had British accent i would never stop talking and i'll explain the whole Oracle organization :-)

Ответить
@ProfessorKaos64
@ProfessorKaos64 - 03.06.2013 22:05

Is it me, or does this guy talk like Christopher Walken :) ?

Ответить
@ProfessorKaos64
@ProfessorKaos64 - 03.06.2013 22:05

Is it me, or does this guy talk like Christopher Walken :) ?

Ответить
@1990shubhra
@1990shubhra - 29.05.2013 17:48

Thank you very much sir great tutorial very practical I got to know what actually Indexes are

Ответить
@ForestAdmin
@ForestAdmin - 18.05.2013 22:18

Great video, I am starting my career as a DBA. And came across the chapters for indexing, and these videos are helping me understand all the theory. Thanks.

Ответить
@chavalikamesh6468
@chavalikamesh6468 - 16.05.2013 15:10

grt say

Ответить
@TAIMIUWU
@TAIMIUWU - 26.02.2013 01:01

brilliant and very informative video. Very helpfull

Ответить
@sajijohn75
@sajijohn75 - 18.01.2013 15:13

Well Presented! Thanks!

Ответить
@aallee125125
@aallee125125 - 28.09.2012 20:14

even though ur voice is a bit scary mate but it was a great help thanks alot mate ta

Ответить
@EdwardKench
@EdwardKench - 06.09.2012 20:38

Thanks for the feedback! Most RDBMS products use some form of the B-Tree index like SQL server. SQL and Oracle are good examples of products that use row-based storage and indexing. However, there are many columnar based databases out there now (e.g. Sybase IQ, Vertica) which do use a different architecture and store data by column instead of by row. These are optimized for fast queries which don't need access to an entire row at a time.

Ответить
@z1reticuli
@z1reticuli - 06.09.2012 13:18

Is there any noticeable difference of how indexes are used on different platforms? Great tutorial btw!

Ответить
@MrSahirkhan1991
@MrSahirkhan1991 - 10.08.2012 00:38

Thank for your HelpFUll Video

Ответить
@johnmathaii
@johnmathaii - 09.08.2012 19:42

Thank you so much

Ответить
@DavidRymell
@DavidRymell - 16.07.2012 01:37

Excellent tutorial: clear, succinct and professional. Thank you.

Ответить
@madhavi1979
@madhavi1979 - 19.06.2012 03:01

Very clear... really helpfull

Ответить
@EdwardKench
@EdwardKench - 27.04.2012 03:54

Thank you for that great feedback!!

Ответить
@mdechelon
@mdechelon - 23.02.2012 12:59

THANXXXX :)

Ответить
@rascalramesh
@rascalramesh - 30.12.2011 17:10

its very useful thanks...........

Ответить
@sreeekanthyou
@sreeekanthyou - 27.12.2011 22:04

this is good one..

Ответить