The optimizer automatically decides the driving table based on statistics.

In table a 1lakh data is present,in table b 20 thousand data is present, to get unique data from table a and b which join to be considered. whether right outer join or left inner join.

Question Posted / oracle enthusiastic

2 Answers
5330 Views
GE, I also Faced
E-Mail Answers

Answer Posted / oracle enthusiastic

The optimizer automatically decides the driving table based on statistics. The join order is immaterial

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How many types of sql are there?

986

What is mutating trigger?

1020

Can you have more than one trigger on a table?

1003

How do I write a sql query in pgadmin 4?

983

What is the difference between python and sql?

1001

what is the difference between truncate and delete statement? : Transact sql

1064

What is delimiter in pl sql?

1062

Are sql connections encrypted?

1023

what is oracle database ? : Sql dba

1028

What is a sql select statement?

1040

Explain about various levels of constraint.

949

What is the need of a partition key?

987

What is sql not null constraint?

1037

what is the difference between ereg_replace() and eregi_replace()? : Sql dba

1153

Is it important to partition hard disk?

1024