Pin Views

  • 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

  • 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/

  • 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

  • FYI DBCC PINTABLE is not supported in SQL 2005

  • cool ! never liked pin table anyway < grin >

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

  • 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