By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,018 Members | 901 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,018 IT Pros & Developers. It's quick & easy.

table design

P: n/a
we have a table with many layers of hierarchy information (child-
parent-grandparent-grandgrandparent-grandgrandgrandparent-...).
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!

Nov 2 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On Nov 2, 5:23 pm, "annecarterfr...@gmail.com"
<annecarterfr...@gmail.comwrote:
we have a table with many layers of hierarchy information (child-
parent-grandparent-grandgrandparent-grandgrandgrandparent-...).
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

Nov 2 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.