Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 343
  • Last Modified:

nested set design question

Hello group,

What are the benefit of using hierarchyid in nested set design in database? base on advice from one of the experts I am using nested set design and of course it has left and right integer values. Using hierarchyid will make a difference as far as optimization or adds up overhead ?

Thanks,
ak
0
akohan
Asked:
akohan
  • 3
  • 2
1 Solution
 
Racim BOUDJAKDJIDatabase Architect - Dba - Data ScientistCommented:
The right and left will mainly be used for navigation. hierarchic is simply redundant information.
0
 
akohanAuthor Commented:
So does it mean using right and left is a better approach and has less redundancy in compare to using Hierarchyid data type?

if so, what do you suggest so I can prove this fact?

Thanks,
ak
0
 
akohanAuthor Commented:
from what I using hierarchyid offers t-sql methods to manipulate data in a tree but on other hand it is a new type and I keep running into negative and positive comments on the web.

any comments?
0
 
Racim BOUDJAKDJIDatabase Architect - Dba - Data ScientistCommented:
<<any comments?>>
I have not tried the new feature but I know for a fact that nested set  works.
0
 
akohanAuthor Commented:
I am using it  now, as newbie of course and it allows you to come up with simpler queries however, you are right ... it has some redundant information which replaces right and left params.

Thank you,
ak
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now