June 22, 2011 at 5:40 am
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
June 22, 2011 at 7:38 am
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
June 22, 2011 at 7:46 am
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