I appologize in advance if this is the wrong part of the forum to post tuning questions on but I am brand spanking new to Netezza.  Let me know where to post it if so and thanks in advance.

I have a query that is taking 1400+ seconds to return in Netezza but in Oracle it completes in only 150 seconds.  I am a complete noobie with Netezza and no training but tasked with reducing query time on it. They are using Netezza as a copy of our prod to do the reporting out of and performance has been as expected but someone formulated a query that is not performing. Since I am told that you don't do Indexes on Netezza and Netezza is made for LARGE volumes of data processing, is it possible that this querys quantity of rows returned makes it faster to do on a regular oracle db with indexes?

Is there ANY kind of tuning to be done and is there a manual anywhere to download on the subject of query performance on this appliance?

Thanks for taking the time to politely reply to this post.

Gib