Options

Projections With Expressions and Statistics

DarinAfniDarinAfni ✭
in General Discussion

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.

 

Darin

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...