Postgres Pro
Downloads
Home   >   mailing lists

Re: sequential scans and the like operator - Mailing list pgsql-general

From Roderick A. Anderson
Subject Re: sequential scans and the like operator
Date
Msg-id Pine.LNX.4.10.10201081042430.14423-100000@tincan.org
Whole thread Raw
In response to Re: sequential scans and the like operator  (Dave Trombley <dtrom@bumba.net>)
Responses Re: sequential scans and the like operator  ("Jeffrey W. Baker" <jwbaker@acm.org>)
Re: sequential scans and the like operator  (Andrew Sullivan <andrew@libertyrms.info>)
List pgsql-general
Tree view 
On Tue, 8 Jan 2002, Dave Trombley wrote:

>     You can always check exaclty what's being done in your queries by
> using the EXPLAIN command.  For example, to test your hypothesis:
>

From your example I'm assuming I don't need data to test the optimizer.
Cool!  This is why I asked (and a little laziness) instead of trying it.
No real data to populate the table with.

Thanks for the idea/knowledge.


Rod
--
                      Let Accuracy Triumph Over Victory

                                                       Zetetic Institute
                                                        "David's Sling"
                                                         Marc Stiegler

pgsql-general by date:

Previous
From: Dave Trombley
Date:
Subject: Re: sequential scans and the like operator
Next
From: "Command Prompt, Inc."
Date:
Subject: Mammoth is born