Post reply

Indexed VIEWs

  • October 17, 2006 at 7:28 am

    #62215

    Hello,

    Is there any point to having a unique clustered index on a VIEW if the one table that it is schemabound to has no indexes on it?

    Thank you for your help.

    CSDunn

  • October 17, 2006 at 7:41 am

    #666204

    I'm looking at some information in BOL that addresses 'Resolving Indexes on Views'. If you have any ideas on this, please share.

    Thanks again!

    CSDunn

  • October 17, 2006 at 8:37 am

    #666246

    Why do you think you need an indexed view in the first place?

  • October 17, 2006 at 9:36 am

    #666277

    Yes, there is value to having an index on a view even if the underlying object has no index on it.  The view is materialized meaning anything using that view will inherently use the index on it.  Instead of being logical it has data structure to it.

    Tom

  • October 17, 2006 at 1:30 pm

    #666344

    Thanks for your help. I'm trying this approach as I explore ways to more efficiently query a table that has eighty two fields, seventeen million records, no Primary Key, and no other indexes. To my knowledge, the table is not partitioned.

    CSDunn

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply