There are 2 tables, table A with 10 million records, table B has 100 million records, now we are joining both tables, when we seen Explain Plan the plan showing TD will took the table A and it will redistributes itNow the Question is: By that plan is the optimizer is correct job or not ? Justify Ans2. From the same above example now the optimizer is taking Table B (100 million records) and it is distributing...

yuvaevergreen

• May 22nd, 2013

Merge join strategies are 1. Big and small table joins - duplicate small tables 2. Column used in join is PI for one table - redistribute the other table in spool. 3. Column used in join is non PI f...

• Sep 18th, 2012

There are 2 tables, table A with 10 million records, table B has 100 million records, now we are joining both tables, when we seen Explain Plan the plan showing TD will took the table A and it will re...

Answer Question  Select Best Answer