Link Details

Link 1171733 thumbnail
User 969765 avatar

By iamondemand
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
  • 100
  • 21

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.

Voters For This Link (2)

Voters Against This Link (0)

    Java Performance Optimization
    Written by: Pierre-Hugues Charbonneau
    Featured Refcardz: Top Refcardz:
    1. Design Patterns
    2. OO JS
    3. Cont. Delivery
    4. Java EE7
    5. HTML5 Mobile
    1. Node.js
    2. Debugging JavaScript
    3. OO JS
    4. JSON
    5. Ajax