Skip site navigation (1)
Skip section navigation (2)
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
- Message-id: <36af4bed0802280631ja29c636w2256fb329e14b95e@mail.gmail.com> <text/plain>
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: