Database Journal
|
SQLCourse
|
SQLCourse2
Register
Help
Remember Me?
Forum
FAQ
Calendar
Forum Actions
Mark Forums Read
Quick Links
View Site Leaders
Who's Online
What's New?
Advertiser Disclosure
Advanced Search
Forum
Oracle Forums
Oracle Database Administration
why nested_loop (9i) and not Hash join (8i) ?
If this is your first visit, be sure to check out the
FAQ
by clicking the link above. You may have to
register
before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.
Results 1 to 4 of 4
Thread:
why nested_loop (9i) and not Hash join (8i) ?
Thread Tools
Show Printable Version
Email this Page…
Display
Switch to Linear Mode
Switch to Hybrid Mode
Threaded Mode
Threaded View
Previous Post
Next Post
11-19-2002,
03:49 PM
#3
khussain
View Profile
View Forum Posts
Senior Member
Join Date
Sep 2000
Location
Chicago, IL
Posts
316
compatible=9.2.0
What else would make the CBO select NESTED LOOPS instead of HASH JOIN ?
Reply With Quote
Quick Navigation
Oracle Database Administration
Top
Site Areas
Settings
Private Messages
Subscriptions
Who's Online
Search Forums
Forums Home
Forums
Oracle Forums
Oracle Database Administration
Oracle Applications DBA
Oracle Development
Oracle Certification
Oracle : How To
Oracle Careers
Oracle Positions Available
Oracle Job Wanted
Archives
Forum Archives
Other
Feedback and Questions regarding the forums
Obfuscation Unlimited
«
Previous Thread
|
Next Thread
»
Posting Permissions
You
may not
post new threads
You
may not
post replies
You
may not
post attachments
You
may not
edit your posts
BB code
is
On
Smilies
are
On
[IMG]
code is
On
[VIDEO]
code is
On
HTML code is
On
Forum Rules
Click Here to Expand Forum to Full Width
Reply With Quote