Subject Re: Using PLAN string in a view
Author patrick_marten
> The constraint is a key (primary, foreign or unique), if you do not
> specify it explicitly in the plan on the view definition there is no
> dependency.
>
> When you execute a query the engine you check the available indices and
> use the best for the query, if you droped some constraint the index will
> not be available, and so, not be used.
>
> So, answering your question, you are right, you will have no dependency
> problem.
>

Hello and thanks for your reply.
I've recreated all views without a custom PLAN statement now.