SQL indexing in 9 minutes and a half
Loading...
Loading...
20,352
Uploaded by roughsealtd on Jan 19, 2009
CAPTIONS AVAILABLE - Full transcript (with some screenshots) available for a small fee at http://stores.lulu.com/konagora/. Proper indexing is one of the keys to database performance - yet a disturbingly high number of people have it more or less wrong. This presentation is based on material from a seminar.
- 66 likes, 3 dislikes
-
Link to this comment:
Share to:
Loading...
- 9:54SQL Index - Compare a clustered index vs a non ...by baghul7,877 views
- 8:26Microsoft SQL Server Index Architectureby AlexRosaVideos7,672 views
- 7:39Oracle SQL Performance Tuningby dwealth20,429 views
- 4:5809 03 Clustered or Non Clusteredby solubletech1,808 views
- 39:16Database System Architectureby ignousocis34,719 views
- 56:25Lecture - 12 Indexing Techniques Multi-Levelby nptelhrd18,544 views
- 7:36SQL - Joins - part 2by ProfMZellers14,413 views
- 7:05Paul takes you through a amazing journey Of Or...by pauljohny20011,570 views
- 1:46Improving SQL Performance with a Clustered Indexby CentriqTraining2,369 views
- 10:31SQL - Primary And Foreign Keysby PCTeachME46,769 views
- 1:18:48Understanding Indexing, by Zardosht Kasheff of ...by tcation1,775 views
- 7:22Introduction to Indexes in SQL Serverby LearnItFirst6,994 views
- 5:54SQL Best Practices in less than 20 minutes 1/3by roughsealtd69,575 views
- 45:58SQL Performance Optimizationby questsoftware70,151 views
- 8:42SQL Best Practices in less than 20 minutes 2/3by roughsealtd39,604 views
- 8:31Introduction to SQL - SQL LESSON 1by handsonerp296,081 views
- 10:36Oracle Tutorial - 10 - indexesby iAspireAcademy7,914 views
- 5:52SQL Joins, nested loops and all that in less th...by roughsealtd35,937 views
- 9:10Rewriting SQL queries for Performance in 9 minutesby roughsealtd17,281 views
No, thank you for teaching.
hemmahbeast 2 months ago
excellent.. teaching method and contents...
shakeosm 4 months ago
probably one of the best tutorials i've seen for indexes
murph1329 6 months ago
extremely funny videos. i am definitely going to have a look at your books. merci pour le bon travaille.
polypus74 6 months ago
Thank you for great tutorial
minami935 7 months ago
Incredible tutorial :D
Akshayphadke 10 months ago
Very easy to understand.
viniciusvh1980 10 months ago
@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.
roughsealtd 1 year ago
@ponghissimo1 He's French..
rsmandudeguy 1 year ago
@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...
AnExplorer1000 1 year ago