Are there any tools available for Informix, similar to 'Query Analyzer' for SQL Server?
+1
A:
Not knowing anything about 'Query Analyzer' for SQL Server, I could be being misled by its name, but...
- The Open Admin Tool has support for analyzing query performance in a number of ways.
- Server Studio (SSJE) has some support for query analysis and performance monitoring.
- The basic server provides SET EXPLAIN to describe a query plan.
- There are numerous performance analysis tools - such as ON-Stat and the pseudo-tables in the SysMaster database.
- There are also some ancient tools such as 'ON-Perf' distributed with IDS that may help too.
Jonathan Leffler
2009-11-24 04:56:23
Hey thanks Jonathan, actually we are looking for a tool to query Informix.
John
2009-11-30 09:21:56
A:
Jonathan's answer is excellent so I'll just confirm that Server Studio is a great albeit overpriced product.
Also to simply (and freely) run Informix Queries you could use Eclipse SQL Explorer
Ilya Kochetov
2010-03-09 10:40:16
A:
We needed a Query Analyzer-like tool for an Informix project some time ago, and settled on RazorSQL, which is Java based, so it's completely platform independent (Windows, MacOS, Linux, etc). About half of the development team at our company uses Macs, so that was a requirement. On top of that, it can connect to any database through JDBC (29 different databases, according to the website).
I've used it extensively on MySQL, SQLServer and Informix, and can confirm it works great on all of them. Before RazorSQL, I was using MySQL tools, and SQLServer Management Studio on a VM, but having a single tool to work with any DB you can throw at it is pretty nice. Also, for accesing Informix from a Mac, it's one of the few options available.
mjuarez
2010-09-06 10:19:58