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.

Which version of this solution are you currently using?

7.0
**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
Find out what your peers are saying about IBM, Oracle, Micro Focus and others in Data Warehouse. Updated: March 2021.
475,705 professionals have used our research since 2012.
Add a Comment
Guest
4 Comments

author avatarit_user517392 (DBA 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 avatarit_user365643 (Sr 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 avatarit_user645135 (Senior 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