Add to Watchlist

SQL Hints, Tips, Tricks, and Tuning

8 views

Citation of segment
Embed Code
Purchasing a DVD Cite video

Automated Media Analysis

Beta
Recognized Entities
Speech transcript
but it
to hear the the the the the the the the the height of the of the Hey hey hey hey hey hey hey hey hey hey hey hey hey and they think that they who was who was who care what v v of B thank thank you you want me but
it but but a but the the the a lot in
but it
Standard deviation
Rule of inference
Slide rule
Computer animation
Database
Open source
Computer
Information technology consulting
Coma Berenices
Expert system
Internationalization and localization
Mobile app
Query language
Database transaction
CL <Programmiersprache>
Set (mathematics)
Point (geometry)
Drop (liquid)
Formal language
Maxima and minima
Query language
Database normalization
Computer animation
Normal (geometry)
Software engineering
Computer animation
Set (mathematics)
Subject indexing
Drop (liquid)
Price index
Database transaction
CL <Programmiersprache>
Set (mathematics)
Point (geometry)
Drop (liquid)
Price index
Rollback (data management)
Formal language
Query language
Database normalization
Computer animation
Network topology
Subject indexing
Computer icon
Computer animation
Uniform resource name
Element (mathematics)
Correlation and dependence
Right angle
Total S.A.
Table (information)
Local Group
Maxima and minima
Metropolitan area network
Clique-width
Price index
Local area network
Euler angles
Table (information)
Number
Duality (mathematics)
Computer animation
Estimation
Military operation
Strategy game
Subject indexing
Row (database)
Loop (music)
Random number
Set (mathematics)
Coma Berenices
Mathematical analysis
Exponential function
Table (information)
Social class
Sample (statistics)
Frequency
Computer animation
Uniform resource name
Statistics
Vacuum
Dean number
Default (computer science)
Data type
Summation
Pointer (computer programming)
Inheritance (object-oriented programming)
Computer animation
Ring (mathematics)
Emulation
Formal grammar
Inheritance (object-oriented programming)
Computer animation
Formal grammar
Partition (number theory)
Inheritance (object-oriented programming)
Computer animation
Mereology
Electronic mailing list
Chi-squared distribution

Metadata

Formal Metadata

Title SQL Hints, Tips, Tricks, and Tuning
Title of Series PGCon 2013
Number of Parts 25
Author Ebrecht, Susanne
Contributors Heroku (Sponsor)
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 license.
DOI 10.5446/19061
Publisher PGCon - PostgreSQL Conference for Users and Developers, Andrea Ross
Release Date 2013
Language English
Production Place Ottawa, Canada

Content Metadata

Subject Area Information technology
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.

Recommendations

Loading...
Feedback
AV-Portal 3.5.0 (cb7a58240982536f976b3fae0db2d7d34ae7e46b)

Timings

  512 ms - page object