Re: A pairwise equation ?

in article pL9B6.8046$E63.141730_at_news1.onlynews.com, Mick Rice at member_at_dBforums.com wrote on 4/11/01 9:00 PM:

> I came accross the term 'pairwise' during the OCP sql exam a couple of
> weeks back. I was fairly stumped as I hadn't come accross it in any of
> my study materials. Has anyone got any idea of what a 'parwise equation'
> is ? Luckily this fact didn't prevent me passing overall ;-)
>
> Thanks,
>
> Mick Rice.
>
>
>
>
> --
> Posted via dBforums
> http://dbforums.com

A pairwise equation is reasonably obscure - it's a type of special arithmetic operation that can be performed on the time series data type. Surprised it's in the OCP.

A pairwise join is basically a parallel join operation - if you have two hash or composite partitioned tables based on the same hash partition key then the join is pushed down into each pair of partitions and performed in parallel early in the execution plan. You can also have a partial pairwise join, where one unhashed table is hashed on the fly to enable the pairwise join. Very effective

Congrats on the certification

FYI - don't know if people are aware of this, because I don't know if it's been officially launched yet, but check out the new search engine on Oracle doc - tahiti.oracle.com - Way cool Received on Thu Apr 12 2001 - 00:13:33 CDT