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.
- 2 Answers
- 4084 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
explain the difference between delete , truncate and drop commands? : Sql dba
what is normalization? : Sql dba
How do I kill a query in postgresql?
What is the difference between left and left outer join?
Do prepared statements prevent sql injection?
what is commit? : Sql dba
Is like operator in sql case sensitive?
What is difference between hql and native sql?
What are the key differences between SQL and PL SQL?
Explain the steps needed to create the scheduled job?
What is the full form of sql?
What does data normalization mean?
what is msql? : Sql dba
What is left join in postgresql?
What are the types of variable use in pl sql?
