[ www.netezza.com ]
Up to Discussions in Enzee Universe
1 Replies Last post: Jan 20, 2010 12:26 AM by Jeff Feinsmith  
manjukini  
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?

Tags: select, count, performance
Jeff Feinsmith  
Jeff Feinsmith
11 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

More Like This

  • Retrieving data ...