the
hashtable built on it.
HTH
Barb
--
From: Steve Rospo[SMTP:[EMAIL PROTECTED]]
Reply To: [EMAIL PROTECTED]
Sent: Thursday, August 23, 2001 7:35 PM
To: Multiple recipients of list ORACLE-L
Subject: hash join order
Does anyone know how the operation below
The order of execution is innermost, upmost first, and so on...
-Original Message-
Sent: Thursday, August 23, 2001 9:35 PM
To: Multiple recipients of list ORACLE-L
Does anyone know how the operation below is performed? Which object has
the hashtable built on it and which object
If you want to see it happen,
alter session set events '10104 trace name context forever, level 1';
alter session set events '10046 trace name context forever, level 8';
The first switches on the hash trace.
The second dumps wait states.
You can watch the hash taking place and see the
data
Does anyone know how the operation below is performed? Which object has
the hashtable built on it and which object performs the lookup against the
hashtable once it's built?
| Operation | Name |
I cannot peoclaim it with absolute authority not being privy to Oracle internals;
however it would make sense to hash the table b_tab.
Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]
-Original Message-
Sent: Thursday, August 23, 2001 6:35 PM
To: Multiple recipients
