Database Administration (MOSC)

MOSC Banner

Creating Materialized View is taking a long time whereas the underlying query lasts a few seconds

edited Jan 28, 2010 12:46AM in Database Administration (MOSC) 7 commentsAnswered
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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center