Jordan Chernev

"Probably at the switch level for those ports that are connected to the rest of your servers/network.   I'm not sure about the internal fabr"

"Is that to be expected?"

"The query execution plans provide this information to an extent. I'm not sure if you can monitor that overall. Maybe Shawn would know more.."

"One thing that you could do is tail the log via   tail -f /nz/kit/log/postgres/pg.log while the sproc is running so you can see exactly whe"

"Nick, I was referring to the bridge table that needs to be built out "manually" by exploding the tree.   If you're in a mixed database envi"

"Does the following work?     ------------------------------------------------------------------------------ -- c) 2010 Netezza Corporation."

"Isn't that one of the most common problems (hierarchy trees) that Kimball describes in his Data Warehouse Desing book? It's worthwhile menti"

"Have you consired using R for your problem? It does great with matrices and all kinds of statistical computations.   I believe IBM Netezza"

"This is the EXPLAIN output of the query correct?   Is it possible to get the actual query and the table DDLs including any distributions/or"

"Harish,   Can you please post any table DDLs, SQL and query execution plans to your problem so we can have a look and provide helpful sugg"

"+1 to Nick's comment on the distribution on the join keys.   Note, you haven't posted the DDL for Table B, I'm assuming you have the same d"

"Also, the way we tackled Netezza -> SQL Server communication in our environment was to build two functions.   One of functions is using OPE"

"Would this be of help here?   CREATE OR REPLACE PROCEDURE TRUNCATE_TABLE(CHARACTER VARYING(ANY)) RETURNS BOOLEAN LANGUAGE NZPLSQL AS BEGIN_"