July 14, 2015 at 8:45 am
Hi,
I am creating mateialized view but it is failing with error that it can't be schema bound.
The query I am working to create materialized view are having joins with different tables and function.
Is it possible to create Indexed views on user defined functions?
July 14, 2015 at 9:08 am
ramana3327 (7/14/2015)
Hi,I am creating mateialized view but it is failing with error that it can't be schema bound.
The query I am working to create materialized view are having joins with different tables and function.
Is it possible to create Indexed views on user defined functions?
My guess, no. Problem is you have not provided us with enough information to give you anything more than that.
It would help if you showed us the DDL for the view and the exact error message you received.
July 14, 2015 at 7:37 pm
If the UDF is created as schema bound, then yes you can include a UDF call within a view definition (and index the view).
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply