Re: Index ot being used - Mailing list pgsql-performance

From Jacques Caron
Subject Re: Index ot being used
Date
Msg-id 6.2.0.14.0.20050610175543.0a63dc88@pop.interactivemediafactory.net
Whole thread Raw
In response to Index ot being used  (linux@alteeve.com)
List pgsql-performance
Hi,

At 18:10 10/06/2005, linux@alteeve.com wrote:
>tle-bu=> EXPLAIN ANALYZE SELECT file_type, file_parent_dir, file_name FROM
>file_info_7;

What could the index be used for? Unless you have some WHERE or (in some
cases) ORDER BY clause, there's absolutely no need for an index, since you
are just asking for all rows from the table...

Jacques.



pgsql-performance by date:

Previous
From: Tobias Brox
Date:
Subject: Re: Index ot being used
Next
From: Clark Slater
Date:
Subject: faster search