utility to time queries
Greg Starnes asked whether Informix has an equivalent of Oracle's SET TIMING ON for tuning queries. Art Kagel said no, but SET EXPLAIN ON reports the optimizer cost, a good comparative indicator if statistics are current, and Jonathan Leffler's sqlcmd has a timer. John Carlson suggested timex dbaccess on UNIX.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
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 */