Abstract: The speed of processing a query, which contains analytical functions is crucial, if we work with a huge amount of data in database. In this article we focused on optimizing the execution of ...