| From: | Roberto Mello <rmello(at)cc(dot)usu(dot)edu> |
|---|---|
| To: | John Cavacas <oogly(at)rogers(dot)com> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: query help/sugestions |
| Date: | 2003-02-09 02:15:10 |
| Message-ID: | 20030209021510.GB31606@cc.usu.edu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
On Sat, Feb 08, 2003 at 12:27:34PM -0500, John Cavacas wrote:
>
> I just started using PostgreSQL recently, and as such I am not sure how
> to properlly evaluate the results of EXPLAIN on that query. I started
> looking at the documentation last night regarding EXPLAIN but I haven't
> gotten my head around it. Any sugestions in that area?
Do you have any specific questions? In general you're trying to get rid of
sequential scans (Seq Scan).
-Roberto
--
+----| Roberto Mello - http://www.brasileiro.net/ |------+
+ Computer Science Graduate Student, Utah State University +
+ USU Free Software & GNU/Linux Club - http://fslc.usu.edu/ +
File not found. Try again? Try again? Ah, come'on, pleeeeeease!
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruno Wolff III | 2003-02-09 04:38:49 | Re: referencing column names properly |
| Previous Message | Sill-II, Stephen | 2003-02-08 23:34:31 | referencing column names properly |