Modern SQL Databases Come Up with Algorithms That You Would Never Dreamed Of

With modern cost based optimisation, relational databases like Oracle, SQL Server, PostgreSQL finally keep up to the promise of a powerful declarative programming model by adapting to ever changing productive data without performance penalties. Thousand-line-long, complex SQL statements can be run in far below a millisecond against billion-row strong tables if database developers know their ways around the SQL language – and the best news is: It’s not that hard! In this talk, I’ll show how the SQL database will constantly outperform any hand written data retrieval algorithm – or in other words – how SQL, being a logic language, is the best language for business logic.

Source: www.youtube.com