fsouza
asked on
Performance Procedure
I can win performance on sql server stored procedure. I need use cursor with fast_forward or while @@rowcount>0 i improve most performance?
A cursor is usually the slowest way to do anything. Can you please post what you are trying to do?
It depends on the situation ... I mostly try to avoid both ... If you explain what you want maybe we can help
P.S. Performance matters if you dealing with large amounts of data
P.S. Performance matters if you dealing with large amounts of data
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
The correct use is CURSOR LOCAL FAST_FORWARD or CURSOR FAST_FORWARD ???
correct use is to avoid both ... atleast read those articles before asking same question again...
it all depends on your scenario which you havent told us yet :-)
it all depends on your scenario which you havent told us yet :-)
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.