netezzaforum.com

Discussion Forum on Netezza, the data warehouse appliance leader

Skip to content

Select query performance

This forum is for you to discuss on NPS Appliance Advanced Concepts like Analyzing/Reviewing plan files, Optimizing Query performance,workload management, Tunable system parameters.
Post a reply

Select query performance

New postby vikranth » 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 ???
vikranth
 
Posts: 1
Joined: Tue Jan 12, 2010 11:46 am
Top

Re: Select query performance

New postby superuser » Wed Jan 27, 2010 3:03 pm

i found the answer for you..http://netezzacommunity.com/message/3763 itseems there is no difference
User avatar
superuser
 
Posts: 24
Joined: Mon Jan 11, 2010 6:11 pm
Top
Post a reply

Return to NPS Appliance Advanced Concepts

Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
Translated by Maël Soucaze © 2009 phpBB.fr
phpBB SEO
cron