March 16, 2006 at 12:03 am
Hi Every one,
when i want to load tables into memory i use DBCC PINTABLE , but what can i do when i want to load VIEWS into memory the command DBCC PINTABLE raise error when trying to invoke views.?
any help pls..
Hoodi
March 17, 2006 at 3:17 am
whilst I think pinning tables is a bad idea - if a table is used frequently it will be in cache anyway - you can't pin a view as it's not a physical object. You could pin the underlying tables.
You might find adding more ram would be a better move than pinning tables which could adversely affect performance.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
March 17, 2006 at 8:25 am
Have a look at "indexed views" header , "view indexes" topic in the BOL. That may either help solve your problem, or at least help explain why you can't pin a view.
jg
March 17, 2006 at 9:47 am
FYI DBCC PINTABLE is not supported in SQL 2005
March 17, 2006 at 9:54 am
cool ! never liked pin table anyway < grin >
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
March 17, 2006 at 11:22 pm
Thanx everybody, i knew my mistake of understanding. Thanx for all efforts.
Hoodi
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply