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
- 4043 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
what is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba
Can you upgrade sql express to full sql?
Explain the order of sql statement execution?
What is the mutating table and constraining table?
What is the difference between partitioning and sharding?
what is csv? : Sql dba
What are few of the schema objects that are created using PL/SQL?
How do you know if a relationship is 2nf?
what is the difference between inner and outer join? Explain with example. : Sql dba
What is difference between pl and sql?
Can you have more than one key in a database?
what are properties of a transaction? : Sql dba
How do I trace sql profiler?
What are the indexing methods?
What is crud sql?
