Hey Everyone!
I've just written a mini-blog on Predicate Pushdown in SQL.
As per predicate pushdown, all the filters in a SQL query are executed as early as possible to reduce the amount of data to be processed further in the query.
Have a look at the blog for some examples along with the query execution plan to understand this!
https://www.linkedin.com/feed/update/urn:li:ugcPost:6959848837117038593?updateEntityUrn=urn%3Ali%3Afs_updateV2%3A%28urn%3Ali%3AugcPost%3A6959848837117038593%2CFEED_DETAIL%2CEMPTY%2CDEFAULT%2Cfalse%29
I've just written a mini-blog on Predicate Pushdown in SQL.
As per predicate pushdown, all the filters in a SQL query are executed as early as possible to reduce the amount of data to be processed further in the query.
Have a look at the blog for some examples along with the query execution plan to understand this!
https://www.linkedin.com/feed/update/urn:li:ugcPost:6959848837117038593?updateEntityUrn=urn%3Ali%3Afs_updateV2%3A%28urn%3Ali%3AugcPost%3A6959848837117038593%2CFEED_DETAIL%2CEMPTY%2CDEFAULT%2Cfalse%29