Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Comments
-
Thank you for your test. Which 11G version are you using? We have 11.1.1.7.150120.
-
Hello Gianni, thanks for your reply, yes I also opened an SR, but I thought I should try my luck here as well. I looked at the log, and the SQL query generated is indeed wrong: it is using the first table (the one with data only after the year 2009) to query data from 2008. The "fragmentation content" is not taken into…