This post originated from an RSS feed registered with Java Buzz by justin cater. Original Post: SQL Tip of the Day: Be Wary of SELECT COUNT(*) Feed Title: Java Code Geeks Feed URL: http://feeds.feedburner.com/JavaCodeGeeks Feed Description: Java 2 Java Developers Resource Center Latest Java Buzz Posts Latest Java Buzz Posts by justin cater Latest Posts From Java Code Geeks

Recently, I’ve encountered this sort of query all over the place at a customer site:                     DECLARE v_var NUMBER(10); BEGIN SELECT COUNT(*) INTO v_var FROM table1 JOIN table2 ON table1.t1_id = table2.t1_id JOIN table3 ON table2.t2_id = table3.t2_id … WHERE some_predicate; IF (v_var = 1) THEN […]