Explore >> Select a destination
|
You are here 
|
blog.codefarm.me | ||
| | | | |
jack-vanlightly.com
|
|
| | | | | My career in data started as a SQL Server performance specialist, which meant I was deep into the nuances of indexes, locking and blocking, execution plan analysis and query design. These days I'm more in the world of the open table format such as Apache Iceberg. Having learned the internals of both transactional and analytical database systems, I find the use of the word "index" interesting as they mean very different things to different systems. I see the term "index" used loosely when discussing open table format performance, both in their current designs and in speculation about future features that might make it into their specs. But what actually counts as an index in this world? Some formats, like Apache Hudi, do maintain record-level indexes such as,... | |
| | | | |
avestura.dev
|
|
| | | | | Have you seen this legendary SQL iceberg meme? Let's talk about it while wearing our PostgreSQL hat! | |
| | | | |
sqlserverfast.com
|
|
| | | | | Welcome to part eleven of the plansplaining series. You will have noticed that this is no longer a monthly series. But when I was asked recently to provide some insight in how a MERGE statement is reflected in an execution plan, I realized that the plansplaining format works fine for this. But first a word... | |
| | | | |
jonathanlewis.wordpress.com
|
|
| | | There is some confusion about the expression "clean" in Oracle circles, so I thought I'd write a short note to explain the different ways in which the word may be applied to Oracle blocks. There are five terms to consider: clean commit cleanout block cleanout delayed block cleanout delayed logging block cleanout Clean: A block... | ||
