Skip to Content
Sep 22, 2014 at 08:57 AM

Records count from Analytic View getting reduced after Hash partitioning


Hi All,

I have a table which is joined to the fact table on Column 'X'. And the Primary key of the table is 'X'.

After I have done the hash partitioning on X, the record count from the query on the Analytic View is reducing.

Couldn't able to paste the code/ write the exact names here as the names have sensitive information.

Any thoughts on this?


Krishna Tangudu