SQL select HAVING is drop performance in WHERE clause

Tutorial66.com
@Share Application Development Skill.

Tutorial is tutorial...66 is My Country Code Up to 10 Years EXP for Application Development Role in Thailand.

Pages: [1]

Topic: SQL select HAVING is drop performance in WHERE clause (Read 119 times)

My Development skill
Java JSP Servlet EJB
Spring Framework
Hibernate Framework
iReport Jasper Report
Apache CXF
PHP Codigniter
Oracle PLSQL
Unix Shell Script

SQL select HAVING is drop performance in WHERE clause

« on: December 28, 2011, 06:25:46 AM »

SQL select HAVING is drop performance in WHERE clause
Use this code for better performance
Not use HAVING in WHERE clause

Code: [Select]

select prod_id,count(prod_id) from  std_table
where prod_type='IT'
group by prod_id;

Instead of this code

Code: [Select]

select prod_id,count(prod_id) from  std_table
group by prod_id
HAVING  prod_type='IT'

Logged

2011@Tutorial66.com
Tutorial for JAVA,PHP,DBMS,Web Developer

SQL select HAVING is drop performance in WHERE clause

Tutorial Category

Topic: SQL select HAVING is drop performance in WHERE clause (Read 119 times)

SQL select HAVING is drop performance in WHERE clause