Helen,

H> There *is* extra cost in the optimizer with views. In the
H> "aim-once-shoot-many" scenario you won't notice it. If your application
H> flow prepares every time, the cost is likely to become noticeable.

just to be sure. Suppose we have some complex select statement and
then we incapsulate part of it into a view. Then our select statement
becomes less complex because some of the criteria have migrated into
the view while others have stayed.

Now, if I understand correctly you are saying that in the case with the
view the prepare phase is more costly. Right? What is this additional
cost due to? Metadata lookups? Dbkeys concatenation? Something else? Is
it quantifiable?

Ciao
--
Nando Dessena
mailto:nandod@...