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
- 4093 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
How to load data with sql*loader?
What trigger means?
Is left join faster than join?
mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql
what is the syntax for using sql_variant_property? : Transact sql
define join and explain different type of joins? : Sql dba
Why do we create stored procedures & functions in pl/sql and how are they different?
How to write html code in pl sql?
What packages(if any) has oracle provided for use by developers?
What does plv msg allows you to do?
Why do we use procedures in pl sql?
Is not null in sql?
How to rename a column in the output of sql query?
What can sql server reporting services do?
How can a function retun more than one value in oracle with proper example?
