|Subject||Re: Using PLAN string in a view|
> 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
> 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
I've recreated all views without a custom PLAN statement now.