Books for you

Oracle8 and later versions can execute index creation, index rebuilds, and index
scans for partitioned indexes in parallel using the same semantics as parallel DML:
one PE process per partition or subpartition of the index.
Fast full index scans for nonpartitioned tables
People often assume that the Oracle database can parallelize index scans only if the
target index is partitioned. Oracle 7.3 introduced the ability to perform parallel index
scans on nonpartitioned indexes for a certain case. If the index scan operation were
???unbounded,??? meaning that the entire index was going to be accessed to satisfy the
query, then Oracle 7.3 and higher would use block-range parallelism to access the
entire index in parallel. While Oracle can perform index scans for nonpartitioned
indexes, this feature applies to a narrow set of queries. Partition-based index scans
apply to a much broader range of queries.
Parallel insert for nonpartitioned and partitioned tables
Oracle can execute an INSERT statement of the form INSERT INTO tableX
SELECT.


Pages:
367 368 369 370 371 372 373 374 375 376 377 378 379 380 381 382 383 384 385 386 387 388 389 390 391