SQL Server Performance

Displaying Hierarchical Data.

Discussion in 'Performance Tuning for DBAs' started by krajdba, Nov 1, 2004.

  1. krajdba New Member

    I have to display Child records and its Sub-Child Records stored in the database based on the Input values of ParentID and the Child record Level.This Child records can go upto Nth Level in an Hierarchical form.

    For this I have considered a Temporary table and a while loop, with which I am facing performance problems.The data is in million.

    I am looking for a replacement of the Temporary table for the above problem.

    Thanks


    raj
    krajdba, Nov 1, 2004
    #2

  2. Luis Martin Moderator

    How about a non temporary table?. Same performance problems?

    Luis Martin
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.

    Luis Martin, Nov 1, 2004
    #2

  3. Chappy New Member

    Google for 'Joe Celko Sql Hierarchy'.
    Chappy, Nov 1, 2004
    #2

Share This Page