Hi,

why is this query

SELECT A.LETO_EFT,

       B.KONSOLIDIRANA_DAVCNA_ST,

SUM(A.KOMAD_ZAVAROVANJA) ST_KOMADOV_ZAVAROVANJ

  FROM DIM..OSEBE B, POL_SNP..CRM A

WHERE ( B.OSEBA_ID = A.PRVI_ZAVAROVANEC_ID OR

        B.OSEBA_ID = A.SKLENITELJ_ZAVAROVANJA_ID )

  AND B.KONSOLIDIRANA_DAVCNA_ST IS NOT NULL

GROUP BY A.LETO_EFT, B.KONSOLIDIRANA_DAVCNA_ST;

taking so long (VERY LONG) versus this one:

SELECT A.LETO_EFT,

       B.KONSOLIDIRANA_DAVCNA_ST,

SUM(A.KOMAD_ZAVAROVANJA) ST_KOMADOV_ZAVAROVANJ

  FROM DIM..OSEBE B, POL_SNP..CRM A

WHERE ( B.OSEBA_ID = A.PRVI_ZAVAROVANEC_ID )

  AND B.KONSOLIDIRANA_DAVCNA_ST IS NOT NULL

GROUP BY A.LETO_EFT, B.KONSOLIDIRANA_DAVCNA_ST 

union

SELECT A.LETO_EFT,

       B.KONSOLIDIRANA_DAVCNA_ST,

SUM(A.KOMAD_ZAVAROVANJA) ST_KOMADOV_ZAVAROVANJ

  FROM DIM..OSEBE B, POL_SNP..CRM A

WHERE ( B.OSEBA_ID = A.SKLENITELJ_ZAVAROVANJA_ID )

  AND B.KONSOLIDIRANA_DAVCNA_ST IS NOT NULL

GROUP BY A.LETO_EFT, B.KONSOLIDIRANA_DAVCNA_ST;