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
- 5189 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 are the built in functions of sql?
Can we use ddl statements in stored procedure sql server?
What is the difference between distinct and unique in sql?
How would you reference column values before and after you have inserted and deleted triggers?
Why partition by is used in sql?
How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?
Name the different types of indexes in sql and define them.
What is pl sql package?
Can cursors be part of a trigger body?
What is sql table?
How does postgresql compare to "nosql"?
Which join condition can be specified using on clause?
What is the default isolation level in sql server? : Transact sql
What are sql*plus environment variables?
Mention what plvcmt and plvrb does in pl/sql?
