]
mon.co.uk cc:
Sent by: Subject: Re: SMJ, NL or HJ
[EMAIL PROTECTED
Notes inline.
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Author of:
Practical Oracle 8i: Building Efficient Databases
Next Seminar - Australia - July/August
http://www.jlcomp.demon.co.uk/seminar.html
Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
Depends. The number of rows matching a given FK may vary widely. Collect stats, and
let the CBO decide, it should not have it too wrong in such a case.
- Original Message -
From: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
Sent: Fri, 03 May 2002 08:13:27
Consider analyzing the EMPNUM column for each table as well, to provide the
CBO with possibly crucial data distribution information...
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, May 03, 2002 11:18 AM
Depends. The number of rows
:
ecorp.com Subject: RE: SMJ, NL or HJ
Sent
Since table B and C are using the same
column to join to table A, then it should be
possible to ensure that Oracle hashes
tables B and C at the same time, then
scans table A passing rows through
each hash in turn. (The order can be
permuted as necessary).
If you can set the hash area size to
PROTECTED]
mon.co.uk cc:
Sent by: Subject: Re: SMJ, NL or HJ
[EMAIL