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
filteronly subset of rows from view. My problem is, that when selecting from this view, optimizer never uses indexes of
neitherof two tables.
I understand, that optimizing the filter to the bottom of query tree may not always give the same result with full join
(althoughit should in my case). Alternative could be to use function returning a table, but I doubt I could use this
functionfrom Crystal Reports. What other options I have?
Tambet