Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. BenediktEngels

    Optimize Hierarchy Query???

    evem though i did not understand completely what you want with your statement (i could not get your result {595,673,720} mayby i missinterpreted your data) seems to be a lot of sequential scans on table list 1a) may be an index on table list, fields node_category_id, node_status, node_id...

Part and Inventory Search

Back
Top