Partitioned views over indexed views

  • Hi,

    I have a table which I would like to partition using partitioned views (on a date) but it has a text column in it so the views can not be schema bound. (I can't change this)

    I wondered if I could create indexed views which filter on date (2009,2010,2011... etc) and then put these in a partitioned view

    e.g. I would like to say SELECT blah FROM <Partitioned View> WHERE Date BETWEEN 01/01/2011 AND 05/05/2011

    This in turn would select the data from the 2011 indexed view ignoring the others.

    Is this possible?

    Cheers

  • Nope.

    That text column is going to be a limiter for you.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • Yeah thought so. Cheers

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

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