Skip to Content
author's profile photo Former Member
Former Member

Navigational Attribute

Hi All,

Why Navigational Attribute Decrease the Query Performance

Thanks in ADV

Add comment
10|10000 characters needed characters exceeded

4 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Aug 03, 2006 at 03:47 AM

    Hi,

    1.When you create a Naviagational attribute apart from SID Table one more Table is created i.e

    X if the attribute is time independant and

    Y if the attribute is time dependant .

    Each time whenever you use the navigational attribute in Query's BW has to scan both SID Table as well as the X and Y Table which leads to performance degradation.

    2. The navigational attributes are stored in the Aggregate and Realignment must happen when the master data changes or for newly loaded master dta. So, Its takes more time for the Attribute Change Run .

    Add comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 03, 2006 at 03:55 AM
    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 03, 2006 at 05:21 AM

    Hi,

    Navigational attribute creates additional table

    X and Y ie. time independent and time dependent.

    When the query is executed database has to fetch the values from these additional table means it has to perform joins between master table and either one of the table. (what joins means is search for the related values in x or y for the current SID) this is the reason for performance degradation.

    It is essential that you create navigaational attribute only when required.

    You feel the pinch more when the data volume is very high.

    Hope this helps!!!

    Add comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 03, 2006 at 05:14 AM

    S S,

    Navigational attributes mean there are joins that need to be created for the query, especially with a large number of records , the time taken for processing the joins is greater and hence the DB time for the quuery willl increase.

    Also when some of the master data changes and if you are using any calculation routines in the loading routines etc , the time taken for the same also changes.

    Hope this helps...

    Arun

    Assign points if useful

    Add comment
    10|10000 characters needed characters exceeded