When I create a view by a query like the follow query:
SELECT DISTINCT ON (o.ordergenkey) o.ordergenkey, lip.payment FROM Ordr o,
LineItemPayment lip
WHERE o.ordergenkey = lip.orderfkey
and o.ordergenkey = ?
The view is created with an ORDER BY clause on the o.ordergenkey...
I think it might be an enforce rule for createing a view with a DISTINCT ON
phrase.
I would like to, if possible, get rid of the ORDER BY clause as it slow the
query to
a crawl.
Any ideas?
-James
James Kelty
Sr. Unix Systems Administrator
The Ashland Agency
541.488.0801
jamesk(at)ashlandagency(dot)com