Postgres Pro
Downloads
Home   >   mailing lists

using a btree index in order by clause? - Mailing list pgsql-hackers

From t-ishii@sra.co.jp
Subject using a btree index in order by clause?
Date
Msg-id 199806170213.LAA08588@srapc451.sra.co.jp
Whole thread Raw
Responses Re: [HACKERS] using a btree index in order by clause?  (Bruce Momjian <maillist@candle.pha.pa.us>)
List pgsql-hackers
Tree view 
Hi,

I'm wondering if we can use btree index to sort the results in a
certain condition. The idea is, if the order-items in the order by
clause have a btree index, then why we need to sort them again?

I'm starting to look at the executor code. However this kind of
"optimization" might be better to be done in the optimizer, I don't
know.

Suggestion?
--
Tatsuo Ishii
t-ishii@sra.co.jp

pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] non-functional update notice unneccesarily
Next
From: Andreas Zeugswetter
Date:
Subject: AW: [HACKERS] using a btree index in order by clause?