DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Non equijoins in Oracle 9i

  1. 07-14-2004, 04:34 PM #1
    lbhagavan
    lbhagavan is offline Junior Member
    Join Date
    Jul 2004
    Posts
    1

    Non equijoins in Oracle 9i

    Does all non equijoin results into nested loop
    if not could you give an example for that, thank you very much
    for your help
    Reply With Quote Reply With Quote
  2. 07-14-2004, 05:33 PM #2
    jmodic
    jmodic is offline Super Moderator
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    But of course not! Why would you think so? What would prevent Oracle from using sort-merge or hash joins when processing nonequijoins?
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?
    Reply With Quote Reply With Quote
« 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
  •  

Forum Rules

Click Here to Expand Forum to Full Width