Re: Index ot being used
От
Jacques Caron
Тема
Re: Index ot being used
Дата
Msg-id
6.2.0.14.0.20050610175543.0a63dc88@pop.interactivemediafactory.net
Ответ на
Index ot being used (linux@alteeve.com)
Список
Дерево обсуждения
Re: Index ot being used "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
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 по дате отправления
