No question at this time
DBA Top 10
1 M. Cadot 7200
2 B. Vroman 3100
3 J. PĂ©ran 2100
4 A. Kavsek 1400
5 P. Tsongayinwe 1300
6 P. Wisse 600
7 D. Walgude 400
7 J. Schnackenberg 400
9 J. Alcroft 200
10 A. Hudspith 100
10 D. Johnson 100
10 B. B 100
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48684
Total active users1329
Act. users last 24h2
Act. users last hour0
Registered user hits last week44
Registered user hits last month221
Go up

Doubt related to join
Next thread: Unable to switch logfile
Prev thread: Dynamic Sql

Message Score Author Date
Hi! I have doubt in oracle joins.I have very go...... frank cadot Jan 17, 2014, 20:01
The former are SQL syntax joins, the latter are ...... Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts Michel Cadot Jan 17, 2014, 20:57
Michel! Thanks & Regards Frank... frank cadot Jan 18, 2014, 18:31
You also have Oracle SQL documentation on joins:...... Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts Michel Cadot Jan 19, 2014, 08:16

Follow up by mail Click here


Subject: Doubt related to join
Author: frank cadot, Ukraine
Date: Jan 17, 2014, 20:01, 3134 days ago
Os info: Linux
Oracle info: Oracle 11g
Message: Hi!

I have doubt in oracle joins.I have very good knowledge of sql.I already know that joins are mainly these types like CROSS JOIN,EQUI JOIN,NON EQUI JOIN,LEFT OUTER JOIN,RIGHT OUTER JOIN,FULL OUTER JOIN,NATURAL JOIN,SELF JOIN.
But when we would discuss and resolve about oracle performance tunning related problem that time we discuss about 1.Sort merge joins,2.hash joins,3.bitmap star joins,4.partition-wise joins and 5.anti joins how do these joins are different from simple Oracle ANSI sql and sql1999 standard.

Thanks in advance
Frank
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Doubt related to join
Author: Michel Cadot, France
Date: Jan 17, 2014, 20:57, 3134 days ago
Score:   Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts
Message:
The former are SQL syntax joins, the latter are access methods.
You choose the former to solve a SQL problem.
The optimizer chooses the latter to access the data.

Start with
http://www.orafaq.com/wiki/Join
and follow its links in "Also see" section.

Regards
Michel

Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Doubt related to join
Author: frank cadot, Ukraine
Date: Jan 18, 2014, 18:31, 3133 days ago
Message: Michel!

Thanks & Regards
Frank
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Doubt related to join
Author: Michel Cadot, France
Date: Jan 19, 2014, 08:16, 3132 days ago
Score:   Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts
Message:
You also have Oracle SQL documentation on joins:
http://docs.oracle.com/cd/B19306_01/server.102/b14200/queries006.htm#i2054012
and access methods:
http://docs.oracle.com/cd/B19306_01/server.102/b14211/optimops.htm#i51523

Regards
Michel
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here