Skip site navigation (1)
Skip section navigation (2)
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
Peripheral Links
Header And Logo
|
Site Navigation
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: Thu, 28 Feb 2008 20:01:19 +0530
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
- Follow-Ups:
- Re: Bypassing useless ORDER BY in a VIEW
- From: Tom Lane
- Re: Bypassing useless ORDER BY in a VIEW
- Prev by Date: Re: t1.col like '%t2.col%'
- Next by Date: Re: Bypassing useless ORDER BY in a VIEW
- Previous by thread: t1.col like '%t2.col%'
- Next by thread: Re: Bypassing useless ORDER BY in a VIEW
- Indexes: