Shivam Saraf
Shivam is a senior studying Computer Science at the University of Waterloo and has a passion for using tools to conjure up software products. Shivam has a keen interest in exploring innovative solutions and pushing the boundaries of technology. Alongside his technical pursuits, he possesses a deep enthusiasm for sports and the lessons it imparts. The combination of technical expertise and a sporting spirit fuels his creativity and problem-solving skills.
Engineering
Increase query speed with Forward Indexes on JSON columns
During the Winter of 2023, I had the wonderful opportunity to work as a Software Engineering Intern on the SQL Queries team at Cockroach Labs. During the scope of this internship, I found myself working with indexes and specifically implementing forward indexes on columns storing JSONB, which resulted in speeding up query execution time by up to 98% in some cases! This blog post will go over the motivations for the implementation of these indexes, the main challenges that came up with the implementation, and some demonstrations of the staggering results.
Shivam Saraf
June 13, 2023