Results 1 to 2 of 2

Thread: Use Hint

  1. #1
    Join Date
    Jul 2002
    Location
    Rome
    Posts
    4

    Question Unanswered: Use Hint

    Hi,

    I have to improvethe creation' s performance of a MATERIALIZED VIEW, is possible use hint in the select that generate it? and do you know a web site that explains the best using of hints and explain-plan?

    thank you so much!
    ciao
    Ale

  2. #2
    Join Date
    Jul 2002
    Location
    Sydney,Australia
    Posts
    44
    Hints are covered well in the Oracle doco
    In the concepts manual and also tuning/performance manual.
    The use of explain plan is also covered extensively as well.

    Do you want the materialised view to be FAST REFRESH? i.e is that what is the slow bit?

    Have Fun
    An Oracle DBAs undocumented init.ora parameters
    _OVERCOME_POOR_DESIGN = TRUE
    _DISABLE_BAD_PERFORMANCE = TRUE

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •