Big News In Databases: Cloud Wars, IBM’s Renaming Insanity, Three Major Releases
Google embraces SQL, SQL Server price reduction on AWS, IBM renames their database, SQL Server 2017 and PostgreSQL 10 released| use-the-index-luke.com
Automatic Rewrite of Date and Time Ranges The following chart shows which DBMS rewrites where clause expressions that access the year part of a date or timestamp (or the like) into a range expression such as ts >= DATE'2024-01-01' AND ts < DATE'2025-01-01'. This enables the use of a sort-based index on the ts column. Unconditionally rewritten — even if only a matching function-based index exists The yellow check marks mean that the rewrite is always done—even if there was a function-b...| Use The Index, Luke!
Upcoming Training: SQL Performance Kick-Start and modern SQL I haven’t blogged here in a while. It doesn’t mean Use The Index, Luke! is abandoned or anything the like. Au contraire, I’m having some topics in the pipeline I’m hoping to blog soon about. Furthermore, Use The Index, Luke! is regularly updated to reflect changes in newer databases releases. The last updates were done a few weeks back when MySQL 8.0 was released (see my blog posts “One Giant Leap For SQL: MySQL 8.0 Releas...| Use The Index, Luke!
Spanish Anyone? The Spanish translation of my book SQL Performance Explained has just been published. It’s the fifth language so far … now there’s a German, English, French, Japanese and Spanish version of the book! You can buy it directly from the book website (PDF or paperback), and some it’s also available through some European Amazon stores (paperback only). The prices are the same as for the other languages: €9.95 for the PDF, €29.95 for the hard copy, €34.95 for PDF+paperb...| Use The Index, Luke!
Google embraces SQL, SQL Server price reduction on AWS, IBM renames their database, SQL Server 2017 and PostgreSQL 10 released| use-the-index-luke.com
New SQL standard released, SQL Server is the database of the year 2016, Oracle’s questionable cloud strategy, and security issues caused by wrong transaction use.| use-the-index-luke.com
The INCLUDE clause for CREATE INDEX is available in some SQL databases: Microsoft SQL Server, PostgreSQL, and IBM Db2 (LUW)| use-the-index-luke.com
