SQL indexing in 9 minutes and a half

[hemmahbeast]

No, thank you for teaching.

[shakeosm]

excellent.. teaching method and contents...

[murph1329]

probably one of the best tutorials i've seen for indexes

[polypus74]

extremely funny videos. i am definitely going to have a look at your books. merci pour le bon travaille.

[minami935]

Thank you for great tutorial

[Akshayphadke]

Incredible tutorial :D

[viniciusvh1980]

Very easy to understand.

[cmetcalf27]

Fell asleep a few times but good.

[ponghissimo1]

You english pronunciation is really bad.

I can hardly understand what you say.

Please improve your pronunciation. Thank you.

[AnExplorer1000]

@ponghissimo1 That's why he has put closed captions... So...

[rsmandudeguy]

@ponghissimo1 He's French..

[CamiloSanchez1979]

Ok, so the question remains, should one index or not? ..i guess the answer is relative

[AnExplorer1000]

@CamiloSanchez1979 Yes, it seems so. The only question that I have concerns the second table with countries and years...is it possible that the search will be done by first looking at the years column even though, in our query, we've put country on the first place (...WHERE country='CHINA'...).

Strange...

[roughsealtd]

@AnExplorer1000

The order of conditions in the SQL statement is irrelevant. Actually "order" is a notion that is completely foreign to the relational theory as designed by Ted Codd. Query optimizers check conditions, check indexes, sometimes rewrite queries, and do as they can to take advantage of existing indexes - if things such as selectivity and distribution of value hint at using the indexes being good for response time.

[Njoiraja]

Very Nice Description of Indexes

Would really appreciate more videos and elaborate discussions from experts like u

[twolittlehorses4me]

would not have dropped my class if I seen this video!

[dave00ster]

Nice description. Thanks for the video.

[bulbish]

thanks for the great tutorials! that's the most i ever learned about databases in just an hour!