Hi Sanjay,
How is this view used usually?
Could you show typical queries with their execution plans and explain plan
for "select/*+ dynamic_sampling(8) */ * from View"?
On Sat, Apr 14, 2018 at 2:35 AM, Sanjay Mishra <dmarc-noreply@xxxxxxxxxxxxx>
wrote:
Select Multiple Columns
from
(select * from table where condition) table1
(select * from table where condition) table2
(select * from table where condition) table3
....
(select * from table where condition) tablenN
where
multiple Join Condition