After being a TA marking hand-written RA queries, as a teacher instituted a LaTeX-typed one. I provided the students with a small stub with everything they needed, and it worked really well.
I would also include Alex Xu's diagram, or yours if you have it, on how a typical query gets evaluated, the one with the blocks etc.
Not knowing data design and not knowing these deep fundamentals on query evaluations result in so much overhead cost. It's really great you're bringing this into focus!
I do know of a startup working on using AI to optimize queries. I can send that info separately, we had a chance to talk at a low-key event.
Please include index-only queries in your index post :)
Thank you! It would be really valuable if you could write an article explaining how the indexing mechanism works, for example, in PostgreSQL.
Excellent post, Ben!
After being a TA marking hand-written RA queries, as a teacher instituted a LaTeX-typed one. I provided the students with a small stub with everything they needed, and it worked really well.
I would also include Alex Xu's diagram, or yours if you have it, on how a typical query gets evaluated, the one with the blocks etc.
Not knowing data design and not knowing these deep fundamentals on query evaluations result in so much overhead cost. It's really great you're bringing this into focus!
I do know of a startup working on using AI to optimize queries. I can send that info separately, we had a chance to talk at a low-key event.
Please include index-only queries in your index post :)
Wow, thank you so much for including my Spark article on the list!