SEO

#1 (**permalink**) 04-20-2008, 11:18 AM

I am very new to informix so be kind.

- Do stored procs have a procompiled/cached query plan in informix? If
you have any links discussing it would be very helpful.
- Does informix have anything similar to DTS packages in MS SQL Server
for doing optimized nightly loads of datafiles? Currently we are using
some incredibily inefficient shell script or compiled external load
program and it is causing major problems holding locks and taking
several hours to complete (i could do this load in SQL Server in under
and hour)

#2 (**permalink**) 04-20-2008, 11:18 AM

zackary.evans@gmail.com wrote:
> - Do stored procs have a procompiled/cached query plan in informix? If
> you have any links discussing it would be very helpful.

Stored procedures are precompiled.
If you enable the relevant caches, then query plans are cached.

URLs? Beyond the generic:
http://publib.boulder.ibm.com/infoce.../v10/index.jsp
Follow the links to Administering, Administrator's Reference,
Configuring and Monitoring, and Configuration Parameters.

Others have answered your second Q about loading.

--
Jonathan Leffler #include <disclaimer.h>
Email: jleffler@earthlink.net, jleffler@us.ibm.com
Guardian of DBD::Informix v2005.02 -- http://dbi.perl.org/

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Easy INFORMIX questions