We're sorry but this page doesn't work properly without JavaScript enabled. Please enable it to continue.
Feedback

SQL Hints, Tips, Tricks, and Tuning

00:00

Formal Metadata

Title
SQL Hints, Tips, Tricks, and Tuning
Title of Series
Number of Parts
25
Author
Contributors
License
CC Attribution - NonCommercial - ShareAlike 3.0 Unported:
You are free to use, adapt and copy, distribute and transmit the work or content in adapted or unchanged form for any legal and non-commercial purpose as long as the work is attributed to the author in the manner specified by the author or licensor and the work or content is shared also in adapted form only under the conditions of this
Identifiers
Publisher
Release Date
Language
Production PlaceOttawa, Canada

Content Metadata

Subject Area
Genre
Abstract
What is the difference between inner, outer, cross and natural join? What is a correlated subselect? What is the advantage and what the disadvantage of an index. Is NOT and OR evil? When do I need normalisation and when denormalisation? All this questions and lots of other performance tips and tricks on SQL level will be given in the talk.
Open sourceComputerStandard deviationDatabaseExpert systemInternationalization and localizationMultiplication signArithmetic meanComputer scienceContrast (vision)NeuroinformatikTouchscreenDatabaseHypothesisOpen sourceInformationWindowComputer animation
Value-added networkRule of inferenceSlide ruleInformation technology consultingComa BerenicesMaxima and minimaSet (mathematics)Query languageComputer animation
Drop (liquid)Formal languageQuery languageCL <Programmiersprache>Database transactionPoint (geometry)
Database normalizationNormal (geometry)Mobile appComputer animation
Price indexSet (mathematics)Engineering drawingDiagram
Price indexSet (mathematics)Drop (liquid)Software engineeringComputer animation
Price indexSet (mathematics)Drop (liquid)Formal languageQuery languageCL <Programmiersprache>Database transactionPoint (geometry)Rollback (data management)Database normalizationNetwork topologyDiagramEngineering drawingProgram flowchartComputer animation
Interior (topology)Right angleTable (information)Element (mathematics)Correlation and dependenceDiagramProgram flowchart
Correlation and dependenceLocal GroupMaxima and minimaUniform resource nameTotal S.A.Computer icon
Local area networkStrategy gameMilitary operationEstimationClique-widthRow (database)NumberProgrammschleifeMetropolitan area networkSubject indexingDuality (mathematics)Euler anglesTable (information)
Price indexRow (database)Duality (mathematics)Default (computer science)Dean numberTable (information)Sample (statistics)Random numberStatisticsSet (mathematics)VacuumMathematical analysisFrequencySocial classUniform resource nameExponential functionComa BerenicesSpecial unitary groupValue-added networkData typeRing (mathematics)
EmulationPointer (computer programming)Formal grammarInheritance (object-oriented programming)SummierbarkeitComputer animation
Inheritance (object-oriented programming)Computer animationDiagram
Inheritance (object-oriented programming)Formal grammarPartition (number theory)Chi-squared distributionMereologyComputer animationProgram flowchart
Electronic mailing listComputer animation
Transcript: English(auto-generated)
C-D-E-F-G.
So yeah. I once made a diploma in computer sciences. I have heavily eye failures. I'm blue blind. And also, I have lots of astigmatism and so on.
And my blue blindness, for us, that I use open source since 1995, 1996, I got a new computer. In my company, I used HP-OX already since a few years. And at home, I used MS-DOS.
And then I got a new computer, and I just saw blue screen. It was Windows 95. And because blue blind means I don't see blue contrast, I didn't see that there was a start button because I couldn't read the start because the contrast wasn't high enough. So I just saw a blue screen.
And I asked my friend, I hope, what the hell is it? And my friends already supported Debian. And so I got Debian and started an open source life. Half a year later, I helped with the first Linux day in Germany.
I used PostgreSQL the first time in 1998. Yeah, I made my diploma thesis in databases on database topics but used informics that time in the early, yeah,
in 2000, 2004, 2004.