Re: extending ORDER BY make query much slower

On Wed, 12 Mar 2003, Dan Langille wrote:

> explain analyse
>   SELECT element.id,
>          commit_log.id AS my_commit_log_id,
>          commit_log.message_id,
>          to_char(commit_log.commit_date - SystemTimeAdjust(), 'DD Mon
> YYYY')  AS commit_date,
>          to_char(commit_log.commit_date - SystemTimeAdjust(),
> 'HH24:MI')      AS commit_time,
>          commit_log.committer,
>          commit_log.description,
>          commit_log.encoding_losses,
>          commit_log.message_subject,
>          element.name,
>          commit_log_elements.revision_name,
>          element_pathname(element.id) AS element_pathname
>     FROM commit_log, commit_log_elements, element
>    WHERE commit_log_elements.commit_log_id = commit_log.id
>      AND commit_log_elements.element_id    = element.id
> ORDER BY commit_log.commit_date DESC,
>          my_commit_log_id
> LIMIT 100;

As a question, is it faster if both are marked DESC?