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?
LVL 2
kintonAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
lahousdenConnect With a Mentor Commented:
The brief answer is "yes" - dimension tables are traditionally less likely to be changing often, so you should be mostly safe from the possibility of presenting inconsistent data...
0
 
Racim BOUDJAKDJIDatabase Architect - Dba - Data ScientistCommented:
<<i.e. will it make processing the cube quicker?>>
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...
0
 
kintonAuthor Commented:
Excellent, thanks for the info guys.
0
All Courses

From novice to tech pro — start learning today.