Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Materialized view
Hi
How can I create materialized view(mv) for the
following statement using 'refresh fast' method.
I can use 'refresh complete'
option to create this mv,
but how can I use 'refresh fast' option for the
below statement in order to improve performance in query.
Any workaround ?
select mas.salesrep_id,sum(del.qty*del.price)-sum(del.discount) from
sales_master mas, sales_details del where mas.transaction_id
=del.transaction_id group by mas.salesrep_id.
Thanks in advance
Received on Wed Jun 25 2003 - 23:44:24 CDT
![]() |
![]() |