Database Profiling

Posted in 2000

Don Ignacio — Thu, 2 Nov 2000 16:15:11 -0500 — source: Informix-list mailing list archive (1991-1998)

Hi All, Does anybody out there know of any tools that actually measures how long a SQL statement executes. Any help will be greatly appreciated. Don

↪ replying to Don Ignacio

Heiko Giesselmann — Thu, 02 Nov 2000 15:42:33 -0800 — source: Informix-list mailing list archive (1991-1998)

Don, if you want detailed analysis of statement execution you should look into I-Spy: http://www.informix.com/informix/products/tools/ispy/index.html . Hope this helps, Heiko Don Ignacio wrote: > Hi All, > > Does anybody out there know of any tools that > actually measures how long a SQL statement > executes. > > Any help will be greatly appreciated. > > Don

↪ replying to Heiko Giesselmann

Thanh — Fri, 03 Nov 2000 13:10:17 GMT — source: Informix-list mailing list archive (1991-1998)

In article <3A01FBE9.9CDDAFC5@informix.com>, Heiko Giesselmann <heiko.giesselmann@informix.com> wrote: > Don, > > if you want detailed analysis of statement execution you should look into I-Spy: > http://www.informix.com/informix/products/tools/ispy/index.html . The techical doc says it only supports IDS-7.2, 7.3, and 8.x What versions (1.0, 1.01, 2.0) of I-Spy will support IDS-9.2x ? Thanks, Thanh > > Hope this helps, Heiko > > Don Ignacio wrote: > > > Hi All, > > > > Does anybody out there know of any tools that > > actually measures how long a SQL statement > > executes. > > > > Any help will be greatly appreciated. > > > > Don > > Sent via Deja.com http://www.deja.com/ Before you buy.

↪ replying to Don Ignacio

Norman Erickson Lugtu — Fri, 03 Nov 2000 20:37:23 GMT — source: Informix-list mailing list archive (1991-1998)

use timex and add user + sys In article <8tsn8u$mtf$1@news.xmission.com>, Don Ignacio <dignacio@openratings.com> wrote: > > Hi All, > > Does anybody out there know of any tools that > actually measures how long a SQL statement > executes. > > Any help will be greatly appreciated. > > Don > Sent via Deja.com http://www.deja.com/ Before you buy.

↪ replying to Don Ignacio

Art S. Kagel — Wed, 08 Nov 2000 13:53:16 -0500 — source: Informix-list mailing list archive (1991-1998)

Jonathan Leffler's sqlcmd has a benchmark option that times every command. Get it from the IIUG Software Repository. Art S. Kagel Don Ignacio wrote: > > Hi All, > > Does anybody out there know of any tools that > actually measures how long a SQL statement > executes. > > Any help will be greatly appreciated. > > Don