Changeset 33619 for trunk/ippTools/share/addtool_checkminidvodbaddrun.sql

Timestamp:

Mar 28, 2012, 4:12:23 PM (14 years ago)

Author:

heather

Message:

the query was not optimal. It's still not optimal but at least it's faster

File:

• trunk/ippTools/share/addtool_checkminidvodbaddrun.sql (modified) (1 diff)

trunk/ippTools/share/addtool_checkminidvodbaddrun.sql

@@ -10 +10 @@
        (SELECT minidvodb_group as minidbg, minidvodb_name as minidbn, count(state) 
         AS cnt 
-        FROM addRun 
+        FROM addRun where minidvodb_group = '%s'
         GROUP BY minidvodb_name ) 
    AS foo1 ON minidvodb_name = minidbn