Tambet Matiisen wrote:
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.Can you add some sql examples - table & index definition, view definition?
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
If your view doesn't contain other views or sub-selects, postgres should use indexes.
Tomasz Myrta
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
