# Reference

0. []()
0. [Inside Snowflake — Optimizing the Query Optimizer: Redundant Semi-Joins and Anti-Joins](https://medium.com/snowflake/inside-snowflake-optimizing-the-query-optimizer-redundant-semi-joins-and-anti-joins-6da855dc56da)
0. [Using Tree Structures with Pagination to build Folder Navigation](https://medium.com/frame-io-engineering/hierarchy-and-pagination-traversing-the-folder-tree-1ba641ec2ce7)