i want have automatically updated structure in sql server can handle aggregate queries well. can create indexed view in sql server 2014 has columnstore index clustered index?
you can't create columnstore index on view per documentation:
create columnstore index (transact-sql)
in limitations , restrictions explicitly states:
"cannot created on view or indexed view."
Comments
Post a Comment