Post reply

Temporary Index needed but the view front ends partitions

  • July 9, 2004 at 1:10 pm

    #161180

    Hi.

    I have a program that runs long.  I think if I had an index on a commonly used field in my where clauses, It would go faster. I query from a view because the supporting tables are partitioned and I must hit a range of partitions.  Is there a way to put an index on a view?  There are hundreds of partitions as we do datawarehousing here.  Any recommendations? 

    Thanks

  • July 11, 2004 at 6:02 pm

    #514220

    If you are using SQL Server 2000, you can create Indexed Views. Have a look in BOL for further info.

    Kindest Regards,

Viewing 2 posts - 1 through 1 (of 1 total)

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