Bypassing useless ORDER BY in a VIEW

From: "Robins Tharakan" <tharakan(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Bypassing useless ORDER BY in a VIEW
Date: 2008-02-28 14:31:19
Message-ID: 36af4bed0802280631ja29c636w2256fb329e14b95e@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hi,

While designing a complex database structure I wanted to ask a basic
question about views.

If I give an ORDER BY clause in a VIEW and then use it in another query
where the VIEW's ORDER BY is immaterial, would the planner be able to
discard this ORDER BY clause ?

Any pointers / feedbacks would be really helpful.

Regards,
*Robins Tharakan*

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2008-02-28 17:13:40 Re: Bypassing useless ORDER BY in a VIEW
Previous Message Oleg Bartunov 2008-02-28 05:47:22 Re: t1.col like '%t2.col%'