Data Distribution SQL

Database

Data Distribution SQL

Hello,
I recently had a node go down due to a hot AMP. This is a very new and small system and logging is not trned on as yet. I suspect a bad query, but want to check overall data distribution. Any tips on a query that will check data distribution across the AMPs for the entire box and not just at a table level?

Cheers
2 REPLIES

Re: Data Distribution SQL

Look for SKEW FACTOR, and the query to show it...

HTH.

Cheers.

Carlos.

Re: Data Distribution SQL

Thanks, Carlos