Re: Big Complex MV creation and Refresh
From: Sayan Malakshinov <xt.and.r_at_gmail.com>
Date: Sat, 14 Apr 2018 02:52:09 +0300
Message-ID: <CAOVevU4aTep5nVx-Ex=dE+DPmuiEDvdvWzWcjSb35FXW2AuyZA_at_mail.gmail.com>
Date: Sat, 14 Apr 2018 02:52:09 +0300
Message-ID: <CAOVevU4aTep5nVx-Ex=dE+DPmuiEDvdvWzWcjSb35FXW2AuyZA_at_mail.gmail.com>
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_at_freelists.org> 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
>
>
>
>
-- Best regards, Sayan Malakshinov Oracle performance tuning engineer Oracle ACE Associate http://orasql.org -- http://www.freelists.org/webpage/oracle-lReceived on Sat Apr 14 2018 - 01:52:09 CEST