Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> DBA HELP: Performane Tune SELECT, SUM, & CASE
HELP!!!
I am trying to fine tune or rewrite my SELECT statement which has a
combination of SUM and CASE statements. The values are accurate, but
the query is slow.
BUSINESS RULE
SQL Code
SUM(CASE WHEN ((FIELD_1 IS NOT NULL AND FIELD_2 IS NULL) OR (FIELD_1 IS NOT NULL AND FIELD_2 IS NOT NULL)) THEN 1 ELSE 0 END) AS Count1 , SUM(CASE WHEN (FIELD_1 IS NULL AND FIELD_2 IS NOT NULL) THEN 1 ELSE 0 END) AS Count2, SUM(CASE WHEN (FIELD_1 IS NULL AND FIELD_2 IS NOT NULL) THEN 1 ELSE (CASE WHEN ((FIELD_1 IS NOT NULL AND FIELD_2 IS NULL) OR FIELD_1 IS NOT NULL AND FIELD_2 IS NOT NULL) THEN 1 ELSE 0 END) END) AS Total_Count, SUM(CASE WHEN ( FIELD_1 IS NULL AND FIELD_2 IS NULL) THEN 1 ELSE 0 END) AS None_Count, FROM TABLE_1Received on Wed Apr 20 2005 - 18:06:42 CDT
![]() |
![]() |