Greenplum Database's parallel query optimizer is responsible for converting SQL or MapReduce into a physical execution plan. It does this using a cost-based optimization algorithm in which it evaluates a vast number of potential plans and selects the one that it believes will lead to the most efficient query execution. Unlike a traditional query optimizer, Greenplum's optimizer takes a global view
![Parallel Query Optimizer | Greenplum](https://cdn-ak-scissors.b.st-hatena.com/image/square/50167b90038ea33fd0dcdf1cdcce6ffc4ac7aad3/height=288;version=1;width=512/http%3A%2F%2Fwww.ndm.net%2Fdatawarehouse%2Fimages%2Fstories%2Fgreenplum%2FGP-Database_Parallel_Query_Optimizer_SQL.png)