|
You are here |
oracle-base.com | ||
| | | | |
jonathanlewis.wordpress.com
|
|
| | | | | 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... | |
| | | | |
rafudb.blogspot.com
|
|
| | | | | Should we use case clause or still use decode? Yet again someting to be aware. Seems like case clause is trimming before comparing. And the ... | |
| | | | |
sqlite-utils.datasette.io
|
|
| | | | | ||
| | | | |
ericposner.com
|
|
| | | A video of the hearing; my testimony. | ||