The Netezza Community: Select count performance

Skip navigation

Netezza.comThinking.Netezza.comBookmark This Site

Up to Discussions in Enzee Universe

14003 Views 1 Reply Latest reply: Jan 20, 2010 12:26 AM by Jeff Feinsmith

manjukini

1 posts since
Jan 11, 2010

Currently Being Moderated

Jan 20, 2010 12:02 AM

Select count performance

Hi Folks

I was googling on net and found some intresting question on select count prefomance on netezza. Thought will post it here..

http://netezzaforum.com/nps-advanced-concepts/select-query-performance-t19.html

Do any one have any idea on this?

Like (0)

Tags: performance, count, select

Jeff Feinsmith
13 posts since
Mar 28, 2007

Currently Being Moderated

1. Jan 20, 2010 12:26 AM (in response to manjukini)
Re: Select count performance

It shouldn't make any difference at all. Both queries project no column data from the database, then perform SPU aggregate on BIGINT value of 1 for each record, and then an aggregate merge on the host.

-Jeff

Report Abuse

Like (0)