Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ffalconer
Starting Member
1 Post |
 Posted - 2010-03-27 : 00:13:30
|
| Is it possible to have a filetered index on a date that entails a range of dates.Eg. createdDate >= sysdate - 35If this is not possible then would it be possible to create the index as mentioned above and just rebuild it periodically.New created data would be included within the filtered index and when the rebuild was done then old data dropped off.ThanksFlint Falconer |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2010-03-27 : 02:45:31
|
No, you can't. The filtered index FILTER clause is rather limited.You can only reference one column in the filter and no functions.
N 56°04'39.26"E 12°55'05.63" |
 |
|
|
|
|
|
Filtered Indexes