Today I am talking about Sql Server 2014 updatabele columnstore index. which feature Microsoft has introduced during released of Sql Server 2012.
columnstore indexes offered significant performance gains over their traditional counterparts.
Sql Server 2012 feature was introduced but some most notably point, there was no way to create clustered columnstore indexes, and the nonclustered columnstore indexes could not be updated. So whenever need to update the data, First we had to drop and rebuild the index or swap out partitions.
New release of Sql Server 2014 adds support for updateable clustered columnstore indexes. It means Sql Server 2014 has provided support for updatable columnstore indexes so you no longer have to drop and re-create columnstore indexes each time you need to load your warehouse tables.
For more detail please visit Microsoft Website
Hope database lover like this post.. Please keep reading...!!
columnstore indexes offered significant performance gains over their traditional counterparts.
Sql Server 2012 feature was introduced but some most notably point, there was no way to create clustered columnstore indexes, and the nonclustered columnstore indexes could not be updated. So whenever need to update the data, First we had to drop and rebuild the index or swap out partitions.
New release of Sql Server 2014 adds support for updateable clustered columnstore indexes. It means Sql Server 2014 has provided support for updatable columnstore indexes so you no longer have to drop and re-create columnstore indexes each time you need to load your warehouse tables.
For more detail please visit Microsoft Website
Hope database lover like this post.. Please keep reading...!!
0 comments:
Post a Comment