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
- 5436 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 many sql are there?
How do you use collections in procedure to return the resultset?
Are subqueries faster than joins?
What is sql*loader?
How to load data with sql*loader?
Write a sql query to get the third highest salary of an employee from employee_table?
Can a foreign key be a duplicate?
what are null values? : Sql dba
How can we link a sql database to an existing android app?
What is Collation Sensitivity ? What are the various type ?
What has stored procedures in sql and how we can use it?
Can we insert delete data in view?
Why stored procedure is better than query?
What is not equal in sql?
What is plpgsql language?
