table design

[annecarterfredi@gmail.com]

we have a table with many layers of hierarchy information (child-
parent-grandparent-grandgrandparen t-grandgrandgrand parent-...).
Relationship built based on two columns (ID, and Parent_ID columns)
While the data model correct and allows us have data like this,
performance of the sql queries is very bad. All the thing that final
users want is faster performance. Can anyone suggest alternate table
design for having hierarchy information?

Thanks!

[Lennart]

Re: table design

On Nov 2, 5:23 pm, "annecarterfr.. .@gmail.com"
<annecarterfr.. .@gmail.comwrot e:

we have a table with many layers of hierarchy information (child-
parent-grandparent-grandgrandparen t-grandgrandgrand parent-...).
Relationship built based on two columns (ID, and Parent_ID columns)
While the data model correct and allows us have data like this,
performance of the sql queries is very bad. All the thing that final
users want is faster performance. Can anyone suggest alternate table
design for having hierarchy information?
>
Thanks!

Troels Arvin has a number of links on the subject at:

http://troels.arvin.dk/db/rdbms/links/#hierarchical

HTH
/Lennart