Hi,
At 18:10 10/06/2005, linux(at)alteeve(dot)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.