IBM Netezza Performance Server Review

It is very fast which makes our life easier to run huge queries for analytics.


Valuable Features:

We use Aginity to access Netezza database. We really like the way we can dominate the physical distribution of the data hence know how to improve the performance of the query. Netezza on its own is very fast which makes our life easier to run huge queries for analytics.

Improvements to My Organization:

This has really helped us to improve the performance of our Data Marts and warehouses. We can run our reports very quickly. It has also improved the turn around time of business requests. 

Room for Improvement:

In Aginity there should be a way to format the SQL queries. I think we can't format the query the way we can do it in Oracle editor (beautifier). Say, for example, if we are trying to get the DDL of an existing view, we lost the formatting. It's a minor issue, but important from usability point of view. Other than this, I think we are good so far with Netezza as a whole.

Use of Solution:

We have been using this product from last 5 years. 

Deployment Issues:

We did not experience any issues.

Stability Issues:

We haven't had any issues.

Scalability Issues:

We've not experienced any issues.

Other Advice:

If volume is the issue, use Netezza. Nothing is better than this product.

**Disclosure: I am a real user, and this review is based on my own experience and opinions.
More IBM Netezza Performance Server reviews from users
...who work at a Financial Services Firm
...who compared it with Teradata
Add a Comment
Guest
4 Comments

author avatarDBA Manager at a media company with 1,001-5,000 employees
Vendor

Netezza box is pretty reliable but we also encountered slowness issues with user doing large queries.

author avatarSr Technical Specialist at a financial services firm with 1,001-5,000 employees
Vendor

It's important how the query is build. In my experience most users don't understand the power of distributed key.

author avatarOrlee Gillis
Consultant

Divya, can you make any recommendation(s) on how to build the queries?

author avatarSenior Systems Executive at a tech services company with 10,001+ employees
Consultant

Use organizing keys and zone maps to help in filtering data and table scans.
Choose the right type of data types especially on the join columns
Join the tables on distribution keys - benefits co-located joins - avoids re-distribution of data