Parallel Access to External Tables (173)
After the metadata for an external table is created, you can query the external data
directly and in parallel, using SQL. As a result, the external table acts as a view, which
lets you run any SQL query against external data without loading the external data
into the database.
The degree of parallel access to an external table is specified using standard parallel
hints and with the PARALLEL clause. Using parallelism on an external table allows for
concurrent access to the datafiles that comprise an external table. Whether a single file
is accessed concurrently is dependent upon the access driver implementation, and
attributes of the datafile(s) being accessed (for example, record formats).
並行訪問外部表
1. 可以使用並行查詢或者直接查詢訪問外部表後設資料
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/10599713/viewspace-981390/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Data Loading with External Tables (172)
- External Tables: Querying Data From Flat Files in OracleOracle
- 【OCP最新題庫解析(052)--題3】Which two are true about external tables?
- 173關
- 【12.2】Oracle 12C R2新特性-外部表支援分割槽了(Partitioning External Tables)Oracle
- 173、贈郭給事
- External Views (33)View
- dba_tables,dba_all_tables,user_tables,all_tables有什麼區別
- oracle hint_no_parallel_no_parallel_indexOracleParallelIndex
- oracle hint_parallel_parallel_indexOracleParallelIndex
- Redshift建立外部架構external schema和外部表external table架構
- ARC173D-Bracket Walk3DRacket
- sqlldr與external tableSQL
- Oracle TablesOracle
- 173. Binary Search Tree Iterator
- Codeforces Round #173 (Div. 2)
- ARC173 解題報告
- ARC173A Neq Number 題解
- Tasks in parallelParallel
- Parallel DMLParallel
- oracle 外部表 external tableOracle
- Oracle外部表 External TableOracle
- ORACLE_DATAPUMP & External TableOracle
- Oracle Externale TablesOracle
- Oracle - Tables/IndexesOracleIndex
- Oracle X$TablesOracle
- Oracle X$ TablesOracle
- Edit SAP tables
- Oracle Partitioned TablesOracle
- MySQL 5.5 LOCK TABLES 和 UNLOCK TABLES 語句介紹MySql
- The differences between index-organized tables and ordinary tables (228)IndexZed
- PostgreSQL DBA(173) - pgAdmin(Network latency)SQL
- about datapump parallelParallel
- 並行(Parallel)並行Parallel
- Oracle Parallel ParametersOracleParallel
- Oracle's ParallelOracleParallel
- Oracle Parallel ExecutionOracleParallel
- Parallel query & viewsParallelView