netezzaforum.com

Hi,

I am trying to select and than insert some 4 billion records in the temporary table. After going through the query plan, I can see that the selection part is getting completed with in 4 minutes but when it tries to insert that data, it takes 10 minutes.

I am distributing the data on 2 columns which are the best choice available for distribution with me. Have already declared columns as 'Not Null' while creating the temporary table.

I am new to netezza and looking out for help with the below questions:

How much time should Netezza take to insert 4 billion records? Do they provide any kind of stats for this?
Is the execution time OK in my case?
If not, please share some thoughts on how can I make is more faster.

Thanks & Best Regards,
Ankur

10 minutes for 4 billion records sounds pretty good to me. How long do you expect it to take to insert 4 billion records? That is an awfull lot of records you know

Hi Gary,

Many Thanks for your views.
Actually, I am new to Netezza as well as to Data warehousing.

Earlier query was taking 2 hrs to run on that much of data which after modification, I brought it to 30 minutes. Main bottleneck is the below part for which I felt that if I could do something to reduce the time to less than 15 mins than that would be gr8.

Hence thought of asking gurus(Masters), if something can be done for this..

Warm Regards,
Ankur