netezzaforum.com

Posted: **Fri Jan 15, 2010 10:00 am**

i heard that in netezza select count(1) from my_table works faster than select count(*) from my_table. is it true? In our scripts we are using select count(*), does select count(1) make a difference ???

Posted: **Wed Jan 27, 2010 3:03 pm**

i found the answer for you..http://netezzacommunity.com/message/3763 itseems there is no difference

netezzaforum.com

Select query performance

Select query performance

Re: Select query performance