Re: Using Index to do sorting while using windowing function

Hi,

By mistake posted this in a wrong user group.

Best Regards,
*Sameer Kumar*

On Wed, Oct 23, 2013 at 10:40 PM, Sameer Kumar <sameer(dot)kumar(at)ashnik(dot)com>wrote:

> Hi,
>
> I was dealing with windowing function recently. I feel they are pretty
> useful and quite handy in lot of operations.
>
> I am not sure why but my PostgreSQL does not seem to be using indexes for
> ORDER BY clause or PARTITION BY CLAUSE which I use with windowing function.
> I have tried ORDER BY and GROUP BY clauses in a normal sql statement and
> they seem to use indexes nicely.
>
> Is this being already considered for development?
>
>
> Best Regards,
> *Sameer Kumar | Database Consultant*
> *ASHNIK PTE. LTD.
> *101 Cecil Street, #11-11 Tong Eng Building, Singapore 069533
> M : *+65 8110 0350* T: +65 6438 3504 | www.ashnik.com
> www.facebook.com/ashnikbiz | www.twitter.com/ashnikbiz
>
> [image: email patch]
>
> This email may contain confidential, privileged or copyright material and
> is solely for the use of the intended recipient(s).
>