All Forums Database
maheshgodi 25 posts Joined 05/06
24 Jul 2008
IMP : New EXPLAIN Terminology

Hi Experts,I run explain plan .I encounter below new EXPLAIN terminology *** are left outer joined using a rowkey-based sliding-window merge join (contexts = 1, 31),with a join condition of ****Please tell/ explain me above EXPLAIN TerminologyThanks in advanceRegards,Mahesh.

idg_tddevex 18 posts Joined 10/06
25 Jul 2008

[font=Verdana][/font]When joining two PPI tables that have equivalent partition definitions, a Row KeyMatch Scan within partitions can be used to join the tables together. Please specify the following inputs to analyse more:1. Type of both tables joined - PPI/NPPI2. PI defined on each table3. Partioning columns 4. Join columns

You must sign in to leave a comment.