Welcome Guest! Log in
×

Notice

The forum is in read only mode.
Due to some maintenance operations, stambia.org will be switched to read-only mode during the 13th November. It will be possible to read and download, but impossible to post on the forums or create new accounts. For any question please contact the support team.

Topic-icon Important Netezza Statistic Offset by 1

More
31 Mar 2017 15:05 #1 by Virginie_Samson
Virginie_Samson created the topic: Netezza Statistic Offset by 1
Hello
Since we use Stambia on Netezza, we always have an offset by 1 beween what is Insert in the database, and what is written in the statistics.
Do you know where it come from ?
Exemple :
Select count(*) from MyTable -> 3418
Stambia Statistics : SUM(SQL_STAT_INSERT) = 3417

Thanks for your hep
Virginie
More
04 Apr 2017 15:56 #2 by risson
risson replied the topic: Netezza Statistic Offset by 1
Does it happen also when there is no source data ? => you get statistic = 1 ?
Maybe there is a special query before the INSERT in the SqlOperation ?
More
05 Apr 2017 17:17 #3 by Virginie_Samson
Virginie_Samson replied the topic: Netezza Statistic Offset by 1
No, it's 0, when there is no data
More
16 Aug 2017 10:59 #4 by Virginie_Samson
Virginie_Samson replied the topic: Netezza Statistic Offset by 1
Hello
Did you find out the problem ?

Thanks