utility to time queries

Does Informix have a SET TIMING ON function? SET TIMIMG ON is the Oracle function. I'm trying to tune a bunch of queries, and would like the db to time the how long the query takes . thanks, gs

Greg Starnes wrote: > > Does Informix have a SET TIMING ON function? SET TIMIMG ON is the Oracle > function. > I'm trying to tune a bunch of queries, and would like the db to time the how > long the query takes . No but SET EXPLAIN ON will report its cost calculation which is a very good indicator of comparative runtimes of queries if the UPDATE STATISTICS have been performed properly and recently. -- Art S. Kagel & Family kagel@erols.com

Greg Starnes wrote: > > Does Informix have a SET TIMING ON function? SET TIMIMG ON is the Oracle > function. > I'm trying to tune a bunch of queries, and would like the db to time the how > long the query takes . > Oh, I forgot to mention, Jonathan Leffler's sqlcmd (dbaccess replacement) implements a timer you can use as you describe. Get it from the IIUG Software Repository. -- Art S. Kagel & Family kagel@erols.com

Greg Starnes wrote: > > Does Informix have a SET TIMING ON function? SET TIMIMG ON is the Oracle > function. > I'm trying to tune a bunch of queries, and would like the db to time the how > long the query takes . > > thanks, > gs Are you in a UNIX environment? I always use 'timex', as in timex dbaccess <dbase_name> <SQL file> -- John Carlson Informix DBA WHSmith USA #include std_disclaimer.h /* These are my opinions, not my company's opinion */