Collocated defines two or more tables located in same database - Oracle Distributed Database concepts

Discussion

• Nirja Shah   -Posted on 21 Sep 15
  - Rewriting your query to access the remote database once is achieved by using collocated inline views. The following terms need to be defined:
  
  - Collocated - Two or more tables located in the same database.
  
  - Inline view - A SELECT statement that is substituted for a table in a parent SELECT statement.
  - The embedded SELECT statement, shown within the parentheses is an example of an inline view:
  SELECT e.empno,e.ename,d.deptno,d.dname
  FROM (SELECT empno, ename from
  emp@orc1.world) e, dept d;
  
  - Collocated inline view - An inline view that selects data from multiple tables from a single database only.
  - It reduces the amount of times that the remote database is accessed, improving the performance of a distributed query.

➨ Post your comment / Share knowledge