Hi All,
Can we use Analytical functions like lead, lag, etc. in FAST REFRESH Materialized Views???
Thnx in Advance
Cheers!
Printable View
Hi All,
Can we use Analytical functions like lead, lag, etc. in FAST REFRESH Materialized Views???
Thnx in Advance
Cheers!
I think u can't use analytical function while creating materialized view with refresh fast option..
Wow!
Hi Tomazz,
May i know why have u given this link?
To support your opinion with documentation...
:confused: why?
Hi Tomazz,
Simple question.. Can we use lag function while creating materialized view with fast refresh option?
Tomaz already gave you the simple answer. Did you read the link he posted?
"Materialized views are not eligible for fast refresh if the defining query contains an analytic function."
Hi Tomazz,
Simple question.. Can we use lag function while creating materialized view with fast refresh option?
huh? are you reading the replies
Thnx for ur help guys...
No Luck still on fast refresh..... :(
Cheers!