Projections With Expressions and Statistics
Is it possible to have projections with expressions and those projections have full statistics? From what I can tell these only have ROWCOUNT statistics.
I have a handful of these projections where I'm converting numeric source data into DATE and TIMESTAMP data types on load. However, I'm not getting the performance lift that I would expect by querying these projections instead of the anchor table. My explain plan shows NO STATISTICS for each join and I would think that's playing a role in the lackluster query performance.
Any advice is welcomed, thanks.