Creating Materialized View is taking a long time whereas the underlying query lasts a few seconds
Hi,
Can't find if it is normal behaviour, but our customer is wondering why...
He issues a query:
SELECT ken.PUBLICATIONDATE as DATUM
, GEENIST.DEPOT_RIT_NR as DEPOT_RIT_NR
, GEENIST.DEPOT_RIT_NAAM as DEPOT_RIT_NAAM
, GEENIST.DISTRICT_NR as DISTRICT_NR
, GEENIST.RAYON_NR as RAYON_NR
, ken.CATEGORIE as CATEGORIE
, ken.ABO_EN_LV_WIJK AS REKENREDEN
, ken.ABO
, ken.ABO_EN_LV_WIJK
, ken.ABO_EN_LVK
, ken.CAT_ABO_MIN
, KEN.CAT_ABO_MAX
, ken.GEM_ABO_PERIODE
, KEN.EURO_VERANTW_VERG_MAZA AS BEDRAG_SOLL
, KEN.UITDEELSTAFFEL
, KEN.VERANTWSTAFFEL
, KEN.TELEFOONSTAFFEL
, KEN.MATERIAALSTAFFEL
Can't find if it is normal behaviour, but our customer is wondering why...
He issues a query:
SELECT ken.PUBLICATIONDATE as DATUM
, GEENIST.DEPOT_RIT_NR as DEPOT_RIT_NR
, GEENIST.DEPOT_RIT_NAAM as DEPOT_RIT_NAAM
, GEENIST.DISTRICT_NR as DISTRICT_NR
, GEENIST.RAYON_NR as RAYON_NR
, ken.CATEGORIE as CATEGORIE
, ken.ABO_EN_LV_WIJK AS REKENREDEN
, ken.ABO
, ken.ABO_EN_LV_WIJK
, ken.ABO_EN_LVK
, ken.CAT_ABO_MIN
, KEN.CAT_ABO_MAX
, ken.GEM_ABO_PERIODE
, KEN.EURO_VERANTW_VERG_MAZA AS BEDRAG_SOLL
, KEN.UITDEELSTAFFEL
, KEN.VERANTWSTAFFEL
, KEN.TELEFOONSTAFFEL
, KEN.MATERIAALSTAFFEL
0