Pro*C optimization: Done when?
From: Jay Ramadorai <76734.3633_at_CompuServe.COM>
Date: 1995/10/05
Message-ID: <450prf$sk1$1_at_mhade.production.compuserve.com>#1/1
Date: 1995/10/05
Message-ID: <450prf$sk1$1_at_mhade.production.compuserve.com>#1/1
Is pro*c static SQL optimized (access path chosen) at precompile
time (with the appropriate semantics/userid options) or run-time?
It doesn't make sense to do it at precompile time as (a) the
statistics can change between precompile and run and (b) the pgm
may be run against a different db than the one it was compiled
against.
However, if it is done at run time, then static and dynamic SQL
should perform the same in Pro*C except for maybe the extra time
taken to perform privilege & object validation for Dynamic SQL?
Any thoughts?
Thanks
-- Jay Ramadorai Software Builders cserve: 76734, 3633Received on Thu Oct 05 1995 - 00:00:00 CET