Hands-on Practical: Analyzing Query Plans

Was this section helpful?

References

Database Management Systems, Raghu Ramakrishnan, Johannes Gehrke, 2003 (McGraw-Hill Education) - This book provides a comprehensive explanation of query processing, optimization, and storage management, including concepts relevant to query plans.
C-Store: A Column-Oriented DBMS, Michael Stonebraker, Daniel J. Abadi, Adam Batkin, Xuedong Chen, Mitch Cherniack, Miguel Ferreira, Edmond Lau, Amerson Lin, Samuel R. Madden, Elizabeth J. O'Neil, Patrick E. O'Neil, Alex Rasin, Nga Tran, and Stan B. Zdonik, 2005 Proceedings of the 31st International Conference on Very Large Data Bases (VLDB) (VLDB Endowment) DOI: 10.14778/1066986.1067035 - This seminal paper introduces the design principles and performance advantages of column-oriented database systems for analytical workloads.
Understanding Query Profile (Snowflake Documentation), Snowflake Inc., 2025 (Snowflake Inc.) - This official documentation guides users on how to interpret Snowflake query plans and identify performance aspects specific to columnar, cloud-native architectures.
Designing Data-Intensive Applications: The Big Ideas Behind Reliable, Scalable, and Maintainable Systems, Martin Kleppmann, 2017 (O'Reilly Media) - This book discusses different storage and indexing strategies, including column-oriented storage, and their impact on query performance.