Hi Frederic,
This looks like a bug. I have logged bug 649 to track this issue. Thanks
for the detailed test case.
Regards,
-Rick
Frederic MOREAU wrote:
Hello,
The optimizer does not take my indexes into account when I do a select
on a 'UNION ALL' type of view ; therefore, table scans are
Hello,
The optimizer does not take my indexes
into account when I do a select on a 'UNION ALL' type of view ; therefore,
table scans are done and performances are bad.
Note : my indexes are taken into account
if I try equivalent selects on tables (instead of views).
Please find below a sample i
