/explore

Click through on any links that interest you or select the planets on the right to continue exploring the Outer Web.
You are here

oracle-base.com
| | apexapplab.dev
2.1 parsecs away

Travel
| | Learn more about the different Layer Types and Geometry Data Types used in the Maps region and why it's important to know them all Why do you need to read this post? Having knowledge of the different types that represent a geometry can give you the opportunity to visualise more and highly complex geometries on...
| | use-the-index-luke.com
9.5 parsecs away

Travel
| | Free. Easy installation. No easy execution plan. INCLUDE clause only for unique indexes. No NULL FIRST/LAST.
| | jonathanlewis.wordpress.com
6.8 parsecs away

Travel
| | I saw a recent tweet (on Bluesky) from SQLDaily highlighting a blog note that Lukas Eder wrote in 2016 with the title: "Avoid using COUNT() in SQL when you could use EXISTS()". This is a good guideline because it probably maximises the options the optimizer has for producing a good execution plan, but it's not...
| | architecturenotes.co
30.1 parsecs away

Travel
| How Relational Databases Work. This post talks about how indexes and transactions work on the inside of relational databases.