Re: Using dimensions

Using dimensionsHm, I did a brief check and it seems I was a bit wrong: Dimensions are required only when you want query rewrite to use materialized views computed on other constraints&relationships than primary/foreign/unique keys. If you want to use your custom relationships in rewrites, you have to use dimensions.

That's at least what I understood from docs:

http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96520/qr.htm#721

Check "trusted" parameter under "Accuracy of query rewrite"

Sorry for misinformation and if you get different understanding docs, please post it here :) Tanel

• Original Message ----- From: Jamadagni, Rajendra To: Multiple recipients of list ORACLE-L Sent: Wednesday, October 01, 2003 3:59 AM Subject: RE: Using dimensions

  Got a link for this requirement in the manual?

  Raj
    -----Original Message-----
    From: Tanel Poder [mailto:tanel.poder.003_at_mail.ee]     Sent: Tuesday, September 30, 2003 4:50 AM     To: Multiple recipients of list ORACLE-L     Subject: Re: Using dimensions

    Query rewriting to use materialized views requires dimensions to be defined.

    Tanel.

• Original Message ----- From: Jamadagni, Rajendra To: Multiple recipients of list ORACLE-L Sent: Monday, September 29, 2003 7:14 PM Subject: RE: Using dimensions

      Thanks Scott, okay lets forget OLTP .. but I haven't seen any _actual_ uses of dimensions ... where does one use them? in SQLs?

      I have scanned TFM, but haven't STFW'd yet ... scared of too many hits.

      Thanks
      Raj
      -------------------------------------------------------------------------------- 
      Rajendra dot Jamadagni at nospamespn dot com 
      All Views expressed in this email are strictly personal. 
      QOTD: Any clod can have facts, having an opinion is an art ! 


        -----Original Message-----

        From: Scott Canaan [mailto:srcdco_at_rit.edu]
        Sent: Monday, September 29, 2003 11:55 AM
        To: Multiple recipients of list ORACLE-L
        Subject: RE: Using dimensions


        Dimensions are data warehouse constructs.  They are implemented as tables in the database, but have the characteristic of a hierarchy that can be traversed.  For example:  a time dimension can have the hierarchy of date, day, week, month, quarter, year, decade, century.  This is used for rollup reporting within the data mart.  I don't see any good use of it in an OLTP environment, but I may be wrong.



        Scott Canaan (srcdco_at_rit.edu)

        (585) 475-7886

        "Life is like a sewer, what you get out of it depends on what you put into it." - Tom Lehrer.





        -----Original Message-----

        From: Jamadagni, Rajendra [mailto:Rajendra.Jamadagni_at_espn.com] 
        Sent: Monday, September 29, 2003 10:55 AM
        To: Multiple recipients of list ORACLE-L
        Subject: Using dimensions



        I have tried, but haven't found a good example of how to _use_ a dimension in 9ir2. I defined one, but then sat clueless on what to do with it. Is it any good in an OLTP environment? (I smell the answer is a NO, but still) ...

        Any notes from your experience? 

        TIA 
        Raj 


        -------------------------------------------------------------------------------- 

        Rajendra dot Jamadagni at nospamespn dot com 
        All Views expressed in this email are strictly personal. 
        QOTD: Any clod can have facts, having an opinion is an art ! 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tanel Poder
  INET: tanel.poder.003_at_mail.ee

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).