Tools for Informix [closed]

开发者_C百科 As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, references, or expertise, but this question will likely solicit debate, arguments, polling, or extended discussion. If you feel that this question can be improved and possibly reopened, visit the help center for guidance. Closed 10 years ago.

Are there any tools available for Informix, similar to 'Query Analyzer' for SQL Server?

---

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.

---

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.

---

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

---

We use Aqua Data Studio, a nice tool which supports different databases.