kinton
asked on
With (nolock) in cube project
Just a quick one, in my cube project, in the Named queries for the dimensions and measure, should I be using With(nolock)? i.e. will it make processing the cube quicker?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Excellent, thanks for the info guys.
Not necessarily. It mainly will decrease the chance for your query to time out by avoiding blocking locks (dirty reads)...If you want to make your processes faster, make sure the feeding processes are well tuned(indexes, structure, code, filegroup, partiion, you name it....)
Hope this helps...