PRODUCT :
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
What is parallelism?
How it impacts on oracle Performance ?
How one can set the parallelism?
What are the Operations, That can be parallelized?
Operations That Can Be Parallelized
Oracle can parallelize operations that involve processing an entire table or an entire partition. These operations include:
SQL queries requiring at least one full table scan or queries involving an index range scan spanning multiple partitions.
Operations such as creating or rebuilding an index or rebuilding one or more partitions of an index.
Partition operations such as moving or splitting partitions
CREATE TABLE AS SELECT operations, if the SELECT involves
a full table or partition scan.
INSERT INTO . . . SELECT operations, if the SELECT involves a full table or partition scan.
Update and delete operations on partitioned tables
Tuesday, September 22, 2009
Subscribe to:
Posts (Atom)
-
Here I am going to discuss some of the differences between Text and String class in Hadoop. Text class lies in the package: import org.ap...
-
Q: What is the library you used in spring to connect to database? Spring JDBC template. Q: What and all involved in fetching the data ... -
AWS AWS Hi! this is for questions related to AWS questions. EC2 instances EC2 storage types cold HDD : 1. Defines performance in terms...