Subject | Re: Using PLAN string in a view |
---|---|
Author | patrick_marten |
Post date | 2012-11-10T09:50:32Z |
> The constraint is a key (primary, foreign or unique), if you do notHello and thanks for your reply.
> 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.
>
I've recreated all views without a custom PLAN statement now.