From: | "Tambet Matiisen" <t(dot)matiisen(at)aprote(dot)ee> |
---|---|
To: | <pgsql-sql(at)postgresql(dot)org> |
Subject: | full join in view |
Date: | 2003-01-08 11:14:24 |
Message-ID: | 81132473206F3A46A72BD6116E1A06AE1B14BC@black.aprote.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
I'm making a report in Crystal Reports, which makes use of full join. As Crystal Reports does not support full join natively, I created a view which contains the join and based my report on that view. The report has also a parameter to filter only subset of rows from view. My problem is, that when selecting from this view, optimizer never uses indexes of neither of two tables.
I understand, that optimizing the filter to the bottom of query tree may not always give the same result with full join (although it should in my case). Alternative could be to use function returning a table, but I doubt I could use this function from Crystal Reports. What other options I have?
Tambet
From | Date | Subject | |
---|---|---|---|
Next Message | Tomasz Myrta | 2003-01-08 13:41:54 | Re: full join in view |
Previous Message | Alan Gutierrez | 2003-01-08 09:34:17 | Re: SQL list table names |