Link Details

Link 1171733 thumbnail
User 969765 avatar

By iamondemand
via scalebase.com
Submitted: Jun 24 2014 / 15:40

I would like to start a series of articles examining query execution paths in a distributed environment. In general, an execution path (or execution plan) is an ordered set of steps used to execute an SQL statement. Queries, in particular, are interesting because of their variety and complexity (people often speak of query plans). In a distributed system, data is spread over a number of databases and therefore collecting and processing data from multiple sources is required. In such an environment, it is vital for the database to choose an efficient execution path. The impact of choosing a sub-optimal execution path is slower responses and more resource utilization manifesting as performance degradation.
  • 2
  • 0
  • 117
  • 23

Add your comment


Html tags not supported. Reply is editable for 5 minutes. Use [code lang="java|ruby|sql|css|xml"][/code] to post code snippets.

Upvoters (2)



Downvoters (0)



    Apache Hadoop
    Written by: Piotr Krewski
    Featured Refcardz: Top Refcardz:
    1. Play
    2. Akka
    3. Design Patterns
    4. OO JS
    5. Cont. Delivery
    1. Play
    2. Java Performance
    3. Akka
    4. REST
    5. Java