Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Any performance impact without distance column in closures?

  1. #1
    Join Date
    Jan 2007
    Posts
    10

    Default Any performance impact without distance column in closures?

    Hi All,

    Currently we are using closure tables without any distance column in it.Will this impact performance of mondrian engine for usage of closure tables?

    As per documentation distance is not strictly required
    "The distance column is not strictly required, but it makes it easier to populate the table.
    "

    Please let me know if distance column in closure table can bring significant improvement query processing

    Thanks
    AJ

  2. #2
    Join Date
    Nov 1999
    Posts
    1,618

    Default

    Mondrian does not use the distance column.

    Dropping the distance column would make the table smaller and therefore the query, oh, 0.001% faster.

  3. #3
    Join Date
    Jan 2007
    Posts
    10

    Default

    Thanks Julian:-)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.