Tools for Informix?

Not knowing anything about 'Query Analyzer' for SQL Server, I could be being misled by its name, but.

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.

Actually we are looking for a tool to query Informix. – John Nov 30 '09 at 9:21.

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.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.