> De: Helen Borrie [mailto:helebor@...]
> Enviado el: viernes 10 de mayo de 2002 15:35

>
> I don't know whether a SP would compile containing a plan,
> but my guess is
> no. Even if it would, it might not be such a good idea,

Plans can be embedded in SP, the courious thing is that in TRG cannot..,

> since the names of
> system-generated indexes change when the database is backed
> up and restored
> and would thus corrupt a compiled procedure that referred to
> these indexes
> by way of a plan.

Wrong, if you use your own rolled index you doesnt have any problems
iusing a plan in SP, and in addition constraints autonamed indexes can
be created using your own named indexes..

I guess that the parser for TRG codes has a bug ..

Saludos ,
Ignacio J. Ortega