Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 5247 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 do I start pl sql?
How would you convert date into julian date format?
What is sql not null constraint?
what is denormalization. : Sql dba
What is index example?
what are the system privileges that are required by a schema owner (user) to create a trigger on a table?
How do I copy a table in sql?
what is try_catch block in procedure
what is the difference between join and union? : Sql dba
What are the advantages of normalization?
What is primary key sql?
What is cross join example?
What is the use of function in sql?
How many sql commands are there?
What is %type in pl sql?
