Specifics of using "IN HIERARCHY" clause in query language

When you use the IN HIERARCHY query language clause, always remember that if you pass a null reference to the parameter, query execution will be slowed because the system will check each item to find out whether it belongs to the hierarchy root. To prevent this, the IN HIERARCHY condition should only be used with a specified item (group), so it is the best choice to make such fields the required ones. If the parameter is not specified (is a null reference), it is better to remove this condition from the query altogether.

Next page: Specifics of using the GROUP BY clause

Be the first to know tips & tricks on business application development!

A confirmation e-mail has been sent to the e-mail address you provided .

Click the link in the e-mail to confirm and activate the subscription.