Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Parallel Execution > What Can Be Parallelized?

What Can Be Parallelized?

The Oracle Database can parallelize a range of SQL statements. Table 2-1 lists the SQL tasks that can be executed in parallel.

The tasks listed in Table 2-1 are not all SQL statements. The actual implementation of parallelism takes place at the level of the subtasks that make up the overall execution of a statement. As an example, the query listed next has four subtasks that can be run in parallel—a table scan of each of the two tables, the join operation, and the aggregation requested.

SELECT customer_name, sum(order_total) FROM customers, orders WHERE
customers.customer_id = orders.customer_id

Image

TABLE 2-1. Parallel Tasks


  

You are currently reading a PREVIEW of this book.

                                                                                                                    

Get instant access to over $1 million worth of books and videos.

  

Start a Free 10-Day Trial


  
  • Safari Books Online
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint