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.
pgsql-performance by date
|Next:||From: Tom Lane||Date: 2008-02-28 17:13:40|
|Subject: Re: Bypassing useless ORDER BY in a VIEW |
|Previous:||From: Oleg Bartunov||Date: 2008-02-28 05:47:22|
|Subject: Re: t1.col like '%t2.col%'|