In postgres you can use the EXPLAIN keyword which will return an analyses of how Postgres will go about carrying out the query including an estimate of the cost in operations performed.
HTH http://www.efn.org/~laprice ( Community, Cooperation, Consensus http://www.opn.org ( Openness to serendipity, make mistakes http://www.efn.org/~laprice/poems ( but learn from them.(carpe fructus ludi) http://allie.office.efn.org/phpwiki/index.php?OregonPublicNetworking On Mon, 22 Oct 2001, Justin Bengtson wrote: > anybody know of a good query analyzer? GPL a plus, must be able to talk to > MS SQL 7, PostGreSQL and MySQL. Debian binary a big plus (no > compliling...) > > this is starting to sound like a personal add... > > "Must be comfortable with skateboarding while chemically inconvenienced." > > also looking for a good combination of CD compilation utilities (burning > from MP3's, wave editting, MP3 to wave converter, etc...) > > i'm looking for personal experience here, folks. i could care less what > google comes up with. > > thanks in advance. > > --------------------------- > Justin ([EMAIL PROTECTED]) > --------------------------- >
