Speeding Up the stored procedure execution..
Hi..!
I've a tree structure of about more than 2 thousand every day i need to scan for each and every node more than 5 times.. I'm using cursor to count left and right nodes of a node in execution....Its consuming so much time...
Is there any way to speed up the execution of these procedures???
plz help me out .. I'm badly stucked........