Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: Functions and Relations

Re: Functions and Relations

From: NENASHI, Tegiri <tnmail42_at_gmail.com>
Date: Wed, 22 Nov 2006 15:57:59 +0100 (CET)
Message-ID: <Xns9883657C0F81Casdgba@194.177.96.26>


"Aloha Kakuikanu" <aloha.kakuikanu_at_yahoo.com> wrote in news:1164159598.933551.91830_at_b28g2000cwb.googlegroups.com:

> 6. `x=1` -> `y=x+1` -> T
> scan the `x=1` relation, then find matching tuples from `y=x+1`, then
> do indexed nested loops join with T. The winner.
>
>

Ah, ok, I see. The treatment number 6 utilizes the unique index and the access is more fast. Interesting, the function like a database relation, I am going to think about it.

--
Tegi
Received on Wed Nov 22 2006 - 08:57:59 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US